ORA-39168: Object path TABLE was not foundParameter file used in export command is:USERID="/ as sysdba"directory=TESTdumpfile=test.dmpSCHEMAS=TEST1INCLUDE=TABLE:"IN ('TEST_1','TEST_2','TEST_3','TEST_4')"SCHEMAS=TEST2INCLUDE=FUNCTION...
impdp 'username/password' directory_name=dir_name dumpfile=dump_filename logfile=logfile.log include=constraint sqlfile=const.sql It produces the following error: ORA-39002: invalid operation ORA-39168: Object path CONSTRAINT was not found.
今天在环境上测试expdp/impdp，环境有10.2.0.5.0，11.2.0.2.0的，11g的环境是从10g升级到11gde...
Oracle Database - Enterprise Edition - Version 11.2.0.3 and later: ORA-39165, ORA-39168, ORA-31655 Invoking Datapump Export with Metadata Filters (INCLUDE/ EXCLUDE)
Connected to: Oracle Database 10g Release 10.2.0.3.0 - Production ORA-39002: invalid operation ORA-39168: Object path GRANT was not found. Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at 15:22:05 Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at 15:22:05...
Oracle Database - Enterprise Edition - Version 10.2.0.1 and later: Datapump Export with Multiple INCLUDE Parameters Raises ORA-39168