• %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....

    ITKE1,150,285 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:
  • Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g

    Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....

    1081080 pointsBadges:
  • VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition

    Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...

    Hunkgym5 pointsBadges:
  • 10G Database Restore to New Server from Backup

    I am a Sr. SQL Server DBA but brand new to Oracle. I have been given a task by my management to perform a backup from our production server and restore it on a brand new server to simulate a disaster. Our environment is Windows 2003 Server and Oracle 10g database. I am having allot of difficulty...

    Sqldatapro0 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.

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

Following