• February 27, 2006 27 Feb'06

    Using traditional and RMAN backup at same time

    Could I use both the traditional and RMAN backup at the same time? Do I need to re-index the table if there is a change in the structure? I have a table ABC with columns A1, A2, A3, A4, A5, A6 and A7. My index is A1, A2, A3, A5. When I run a query ...  Continue Reading

  • February 27, 2006 27 Feb'06

    Which instance is a user connected through?

    You said in one of your answers that "In normal configurations (without RAC), if the instance goes down, you no longer have access to your data. In RAC environments, if an instance goes down other instances can still access the data." How will it be...  Continue Reading

  • February 27, 2006 27 Feb'06

    Restoring DBF files

    I have just installed Oracle 9i into a Windows XP Server. I have to restore the DBF files. How am I going to restore the data to the database? Using RMAN? Actually these DBF files were copied from another XP server. I have stopped the Oracle ...  Continue Reading

  • February 27, 2006 27 Feb'06

    Startup sequence for 9i database

    I am new to Oracle Database. Please tell me the startup sequence for an Oracle 9i database. I am unable to understand which things start first and how the things are arranged.  Continue Reading

  • February 27, 2006 27 Feb'06

    Doing an export while someone is using the system

    What happens if we do an Oracle database export while someone is signed onto the system? Will any files be omitted?  Continue Reading

  • February 27, 2006 27 Feb'06

    How to import data to a different user?

    I'm a DBA and I have data and a database created by user SAMRUDHI. I then export the data by using the exp samrudhi/smu@shimul grants=y command. If I want to import the table to another user by name SINI it shows the message that the backup was done...  Continue Reading

  • February 23, 2006 23 Feb'06

    Primary key enforced by unique index

    What does "the primary key of the table is enforced using a non-unique index" really mean?  Continue Reading