Hello together,
at a 11.2.0.4 database (OS of the server is OEL 7.2) I'm trying to import a Data Pump export splitted in three files in that way:
impdp system directory=DB_EXPORT dumpfile=expTBLwhere_01.dmp,expTBLwhere_02.dmp,expTBLwhere_03.dmp logfile=IMP_ITMSYS_20170126_35795_DAPA_14.log parallel=4 partition_options=DEPARTITION exclude=TABLE:\"IN \(\'TAKTIVERJOB\',\'TADRESSE\',\'BENUTZER\'\)\"
Something is wrong with the three excluded tables, so we don't use them actually.
Unfortunately I'm getting an error, seems that an index isn't able to be created:
ORA-06502: PL/SQL: numerischer oder Wertefehler: NULL index table key value
So first to look if the index are the bad boys I will exclude them also. First I've tried this:
impdp system directory=DB_EXPORT dumpfile=expTBLwhere_01.dmp,expTBLwhere_02.dmp,expTBLwhere_03.dmp logfile=IMP_ITMSYS_20170126_35795_DAPA_15.log parallel=4 partition_options=DEPARTITION exclude=INDEXES,TABLE:\"IN \(\'TAKTIVERJOB\',\'TADRESSE\',\'BENUTZER\'\)\"
But I'm getting this:
ORA-39041: Filter "EXCLUDE" identifiziert alle Objekttypen oder keine Objekttypen.
OK, he needs some more details, but I want to exclude really all indexes that are in the dump files. So I've tried this:
impdp system directory=DB_EXPORT dumpfile=expTBLwhere_01.dmp,expTBLwhere_02.dmp,expTBLwhere_03.dmp logfile=IMP_ITMSYS_20170126_35795_DAPA_14.log parallel=4 partition_options=DEPARTITION exclude=TABLE:\"IN \(\'TAKTIVERJOB\',\'TADRESSE\',\'BENUTZER\'\)\",INDEXES:\"IN \(\'\%\'\)\"
But now I'm back at this error:
ORA-06502: PL/SQL: numerischer oder Wertefehler: NULL index table key value
Is there any other way to tehh impdp to let out all indexes for checking just data integrity of the dump file?
Thanks and regards,
David