CODEWITHSUNDEEP
oracle-databasedatabase-administrationdblinkimpdpexpdp
unciahan
unciahan

Reputation: 1

ORA-00904 whlie executing impdp

I'm trying to import ORIG schema into TEST schema.
ORIG schema was exported with filename exp_orig.dmp.

Following are the command I executed and its referencing parfile(imp_testdb.par).

command :
impdp TEST/123@TESTDB parfile=imp_testdb.par

imp_testdb.par :

remap_schema=ORIG:TEST
dumpfile=exp_orig.dmp
logfile=imp_test.log
directory=ORA_IMPROT
logtime=ALL
metrics=YES
exclude=DB_LINK
table_exists_action=REPLACE

When I execute the command, it crashes with following errors :

ORA-39068: invalid master table data in row with PROCESS_ORDER=-13
ORA-00904: "TAG": invalid identifier

I have no idea how to debug ORA-00904 and I couldn't find solution on google which applies to my situation, so I tried validating things one by one.

  1. I created another user with the same spec and impdp to that user failed with same errors.
    => so it wasn't specific to target schema

  2. I exported(expdp) the original schema again and impdp with the new file failed with same errors.
    => so it wasn't specific to a dumpfile

  3. Then I started validating the parfile parameters
    => when I took out exclude=DB_LINK option in the parfile, impdp was successfully executed.

What reason could this possibly be due to?

Upvotes: 0

Views: 270

Answers (0)

Related Questions