how to clone 9i Database on to 10g Database.
Answer / Anuradha Singh
You can use Data Pump Export/Import utilities to migrate data from a 9i database to a 10g database. Here is a high-level step-by-step guide:
1. Export the data using expdp utility on the 9i database.
2. Create a directory for the import data on the 10g database.
3. Import the data using impdp utility on the 10g database.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is meant by a deadlock situation?
find out first highest salary?
10 Answers Verinon Technology Solutions,
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
how the indexes are stored in the Oracle Database?
Explain about functional dependency and its relation with table design?
How to get a list of all user accounts in the database?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What is rowid and rownum in oracle?
How do I know if oracle client is installed on windows?
Why we choose emp number as primarykey?
why can't we assign not null constraint as table level constraint
How to delete a column in an existing table in oracle?