Hi,
As the title, I want to migrate database by using data pump. But there are a lot of errors during the importing process such as:
ORA-31693: Table data object "OWNER"."JOBS_LOG":"P_201810" failed to load/unload and is being skipped due to error:
ORA-00001: unique constraint (OWNER.JOBS_LOG_PK) violated
I have check data in source database and found that there is duplicate data (of course). I mean why the constraint is ok in source database but it got this error during the importing process.
Another error is like:
ORA-31693: Table data object "PLATFORM"."TRANSACTION" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-02291: integrity constraint (PLATFORM.SYS_C0011790) violated - parent key not found
So how to make sure that all tables with parent keys will be imported before tables with child records?
Could I control the order of importing process?
Furthermore, the table PLATFORM.TRANSACTION has no foreign key, all constraint is NOT NULL constraint and I still got this error during the importing proces:
CREATE TABLE PLATFORM.TRANSACTION
(
ID NUMBER(19) NOT NULL,
CREATED_AT DATE DEFAULT CURRENT_TIMESTAMP,
UPDATED_AT DATE DEFAULT CURRENT_TIMESTAMP,
QUERY_IP VARCHAR2(32 CHAR) NOT NULL,
SERVICE VARCHAR2(64 CHAR),
RESPONSE_TIME DATE NOT NULL,
MESSAGE VARCHAR2(1024 CHAR),
TRANSACTION_ID VARCHAR2(16 CHAR) NOT NULL,
)