ORA-31684错误是Oracle数据库在使用数据泵(Data Pump)工具进行数据导入(import, impdp)时遇到的一种错误。该错误表明在尝试导入某个数据库对象时,发现该对象已经存在于数据库中,导致导入操作无法继续。错误消息通常会明确指出存在冲突的对象类型及名称,如“Object type CONSTRAINT:"SMP"."SYS_C0056287" already exists...
Oracle Database Cloud Schema Service - Version N/A and later: DataPump Import (IMPDP) Error ORA-31684 Object type REF_CONSTRAINT:"<SCHEMA_NAME>"."<FK_NAME>" already
You checked the DDL statements in SQLFILE extracted from dump file and observed, the primary key constraint is already present inline in column list (what implicitly creates the unique index with same name). Additionally a unique index is created: During the execution (import), the additional CR...
ORA-39083: Object type TABLE failed to create with error: ORA-2270: no matching unique or primary key for this column-listor:ORA-31684: Object type CONSTRAINT:"<CONSTRAINT_NAME>" already exists Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS ORA-39111: Dependent ...