Oracle Database Discussions

Hi,

What is the correct way to import into a new database ?

I have an export of an existing database (say 8i) and I need to clone it under a new name (lets assume on the same machine).

1. Export the existing database
2. Create the necessary folders / init.ora / run db creation script / run catalog & catproc / create TS
3. Import as : imp system/password@newdb file=xx full=y ignore=y

Do I set "ignore" or not ? Either way I run into some errors with sys / system tables ; such as :

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_OBJECT_TYPE_PK) violated
Column 1 -1005
Column 2 SYNCHRONOUS UPDATABLE TABLE
Column 3 02
Column 4
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYSTEM.REPCAT$_OBJECT_TYPE_PK) violated
Column 1 -1004
Column 2 ASYNCHRONOUS UPDATABLE TABLE
Column 3 00
Column 4

(BTW .. This is a 10g DB I was importing into) But I am assuming the errors with sys / system would likely happen on older databases as well (for sys or system tables).

OR is it better to create the new DB and import individual schemas ?

Can someone shed some light on the correct way to ensure the new clone is 100% fit ?

Thanks.

Edited by: user4874781 on Jan 29, 2009 6:20 PM