Hi Everyone,
We have created a New Database on a Different server and we are trying to Import Dumpfile from production using IMPDP (12c to 12c), and we are getting:
ORA-31684: Object type CONSTRAINT:"PRODONE"."SYS_C00213326" already exists.
There are no users Created nor existing as this is a Newly created Database.
Used to Export using the Below Command:
EXPDP 'sys/qwerty@PROD as sysdba' DIRECTORY=EXPDP DUMPFILE=DEV_EXPDP_FRI-06-09_300.dmp LOGFILE=PRODONE_EXPORT_12C_09JUNE2023.log SCHEMAS=DEVONE PARALLEL=2 COMPRESSION=ALL
Used to Import using the Below Command:
IMPDP 'sys/qwerty@SFMS as sysdba' DIRECTORY=EXPDP DUMPFILE=EXPDP DUMPFILE=DEV_EXPDP_FRI-06-09_300.dmp LOGFILE=IMPORT_PRODONE_EXPORT_12C_09JUNE2023.log .log SCHEMAS=DEVONE PARALLEL=2 TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
Any help would be much appreciated.