• Database problem of Stop working

    We are working in Oracle 10g on Linux Debian 32 bit, A week back we had a problem that i was unable to access any tool of oracle in the morning, Everything was fine previously . when i try to write any command server was too slow and when i use sqlplus it is unable to run no reply then i use top...

    IRFANB1465 pointsBadges:
  • Oracle Application Server

    I need to install Oracle Application Server 10g on HP Proliant DL580 with dual-core 64-bit Intel Xeon processor (7140M), & with Windows 2003 64-bit. I couldn't find any version or release for such environment, but I found for the Itanium processors. Kindly advise me about the right version &...

    Saadeddine0 pointsBadges:
  • %rowcount in 10G

    Can we use %rowcount in oracle 10G and if not what is the solution?

    Answerpls1230 pointsBadges:
  • how to store information in variables accessible to procedures in the packages??

    how do i store information in variables which are accesible by more than one procedures in the same package?? (i.e. i want to take input information using a procedure and i want to call other procedures internally which will use these input information to give results...) CAN ANYONE HELPME ON...

    Shankar o5 pointsBadges:
  • Problem in oracle 10G form

    I want to add a picture in oracle 10G form by clicking button or image item and then want to save it in data base using long raw data type. Please tell me how can I add it.

    030495 pointsBadges:
  • Temp Tablespace in 10G

    have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i've no effect

    DAC15 pointsBadges:
  • 10 g Temp Tablespace always shows full in OEM.

    have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i've no effect.Every day I increase the size of temp tablespace.Night we run some procedures and morning temp tablespace shows Full.

    DAC15 pointsBadges:
  • Oracle Patch

    Oracle Patch p4898608_10203_GENERIC to AIX and p6079591_10203_AIX64-5L. I have already apply the patch p5337014_10203_AIX64-5L. Shall I follow the same procedure to apply the above 2 patches. I have not been given proper document to apply the above 2 patches by my previous people. Please advise....

    Subbiah5 pointsBadges:
  • Oracle froms n Reports installation error

    Hi All, I am trying to install oracle 10g form & Report on HP unix 11.11 I am getting following error. Starting Oracle Universal Installer ... Checking requirements... Checking operating system version: must be B.11.11 or B.11.00. Actual B.11.11 Passed All requirements met. Checking if CPU speed is...

    Dnyanu5 pointsBadges:
  • Trouble logging on to Oracle 10g database remotely

    This question was emailed to us I installed the oracle 10g (10.1.0) on a windows 2003 server where we already have Oracle 9i (9.2). I am able to login on the 10g DB from server but when I try to login remotely it gives the error ORA-12500: TNS:listener failed to start a dedicated server process....

    ITKE350,790 pointsBadges:
  • username and password is asking oracle 10g database

    i installed oracle 10g dba clint side in my pc, but username, password and string is asking pls help me sir/madam

    Unix5 pointsBadges:
  • DBCA not opening

    Hi what could be the reason behind not opening the DBCA in Oracle 10g?

    Sr123470 pointsBadges:
  • Parameter file

    Hi I have installed Oracle 10g Win 2003 server, as I know there are 2 parameter files one is dynamic and other is static. how do I know that which parameter file is being used? If I go to EM DBcontrol "all Initialize parameter file" I can see SPFILE is disabled, means dynamic parameter file is not...

    Sr123470 pointsBadges:
  • finding difference between two different rows of a column

    Hi aLL, I have a database running oracle 10g. I want to know if there is an oracle function that takes care of difference between two values in two different rows of thesame column. Thanks Soga

    Soga5 pointsBadges:
  • Replication of Oracle 10g to 8i

    Dear Sir, We are using Oracle 8i in our production and we have a plan to upgrade it to Oracle 10g. Lets say we have upgraded our production database to Oracle 10G and it is working fine for 1 day. After a day, lets say we found an show stopper issue which cannot be fixed in the near future. Now in...

    Arunilan15 pointsBadges:
  • Oracle 10g Data Pump export through EM DB control

    When I am going to use Oracle 10g data pump export, after entering of OS user name and password and do OK, it is giving me "RemoteException Error: wrong password for the user" why this error is coming pl. give me any solution thank you

    Sr123470 pointsBadges:
  • SQL behaves differently in two identical Oracle 10g db’s

    I have a SQL statement that is behaving differently in two "equal" databases (equal in schema, but size differs by about 50%). Here's the statement: select distinct 99, 31, b.school_id, a.provider_id, a.student_id, '2007', lpad('01',2,'0'), '0' from studprovider a, student b, school c where...

    Sprevost5 pointsBadges:
  • media recovery

    Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....

    Sukaina10 pointsBadges:
  • How to update a oracle table containing 4 billion records

    I want to update a column on the table containing 4 billion records. The table is partitioned and all partitions are compressed except the current month. I created the following procedure to do the update (I will do the update per month): create or replace procedure update_datetime_cdrdatanew is...

    Ws8oBPSQ15 pointsBadges:
  • How can I update a huge Oracle table containing 4 billion records

    I want to update the table containing 4 billion records. The table is partitioned and all the partitions are compressed except for the current month. I added 1 column to the table and must update the column with a value. I created a procedure that must do the update. Procedure: create or replace...

    Ws8oBPSQ15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following