• November 30, 2005 30 Nov'05

    What is a surrogate key?

    What is a surrogate key in a table?  Continue Reading

  • November 29, 2005 29 Nov'05

    Copying a database with Arabic fonts

    I need to make a copy of a DB in 9i on Windows 2003 Server but I have Arabic fonts. I tried to do this with exp and imp, but all fonts in Arabic were lost. I tried to adjust the character set for the new database with no success.  Continue Reading

  • November 29, 2005 29 Nov'05

    Creating a query to hit an index

    I have a few doubts about index creations. I have a table called PLANTEST. Now I have created two non-unique indexes, for both the columns separately. But when I execute the below query, the system is not hitting the index. Can you please tell me ...  Continue Reading

  • November 29, 2005 29 Nov'05

    How is the bitmap index stored?

    Can you tell me how the bitmap index is stored? Basically I want to know the way it is stored inside the database and, during retrieval, how it is used to retrieve rows based on that.  Continue Reading

  • November 29, 2005 29 Nov'05

    Updating changes to DB objects with new releases

    We are developing a large application base on PL/SQL. We often have to change DB objects. The biggest trouble comes with every new release. To enhance our application we have to know about the latest state of all DB objects. To find this out, we ...  Continue Reading

  • November 29, 2005 29 Nov'05

    Problems installing 8i Enterprise Edition on XP

    I am trying to install Oracle8i Enterprise Edition on Windows XP, SP2, and for some reason, when I either click on setup.exe or try to run from the command line, the Universal Installer does not start. In fact, I don't even see it start up and run ...  Continue Reading

  • November 29, 2005 29 Nov'05

    Dumping data from 10g to 9i

    How to dump data from Oracle 10g to Oracle 9i? Or, how to move the dump from a 10g database to a 9i database?  Continue Reading

  • November 29, 2005 29 Nov'05

    Archive log files generating quickly

    Yesterday users complained that performance was going down; after than I checked in the database and I found that archive log files are generating very quickly, nearly two archive log files in a minute with a size of 100 MB each. But normally it ...  Continue Reading

  • November 29, 2005 29 Nov'05

    Configuring TAF parameters in RAC

    I have a question regarding Oracle 9i RAC database. We have two nodes that are concurrently accessing the same database in a RAC environment on Sun boxes, and we have a total of 300 users. We want to use the RAC feature to call Transparent ...  Continue Reading

  • November 29, 2005 29 Nov'05

    Operation hanging during installation

    I am trying to install on Windows 2003. It succesfully installed Oracle and performed the Net Configuration. When it creates the database through DBCA and goes to option COMPLETING DATABASE CREATE and tries to "clone the database," the ...  Continue Reading

  • November 29, 2005 29 Nov'05

    Exporting from command line

    How can I export from the command line all triggers, procedures, functions, etc. from an Oracle database?  Continue Reading

  • November 29, 2005 29 Nov'05

    Capturing change in every column in every table

    We have a scenario where I need to capture change in every column of every table in my database. Kindly suggest the pros and cons of the available alternatives, and the process of retrieving the old and new data when required as per the ...  Continue Reading

  • November 29, 2005 29 Nov'05

    Which IMP messages are warnings and which are errors?

    How can you differentiate in Oracle 9i between import messages (IMP-nnnnn) that are warnings and the ones the are error messages? For example, in case of IMP-00015 the import will terminate successfully with warnings, but in case of IMP-00022 or ...  Continue Reading

  • November 29, 2005 29 Nov'05

    Can I reset the SYS password?

    I am using Windows XP and I have Oracle 9i installed on it. I can't get into Oracle using the SYS account. It either tells me 'you are no longer connected to Oracle' or 'you have no sufficient privileges' when I log on as SYSDBA. Is there a way ...  Continue Reading

  • November 29, 2005 29 Nov'05

    Are column headers exported along with data?

    I am new to Oracle and have one simple question regarding data export. Will the column headers be exported along with the data?  Continue Reading

  • November 29, 2005 29 Nov'05

    ORA-12537 error when trying to connect

    I installed Oracle 8.1.7 on Windows 2000 and got this message when I tried to connect to my database from the client's PC: "ORA-12537 TNS:connection closed."  Continue Reading

  • November 29, 2005 29 Nov'05

    Planning for migration from 8i to 10g

    We are planning a database migration from Oracle8i to Oracle 10g. What is the release date of Oracle 10g Release 1? Is there a 32-bit Oracle 10g Release 1 database available for HP-UX 11.11?  Continue Reading