I am new to oracle and i have received the next assignement.
I have a dump file created with expdp but it was supposed to be created with exp. In order to do that i want to import that file with impdp and export it back with exp.
But I receive the following error:
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
ORA-39083: Object type COMMENT failed to create with error:
ORA-00942: table or view does not exist
Failing sql is:
COMMENT ON TABLE "DAB1"."MLOG$_TABLE1" IS 'snapshot log for master table DAB1.TABLE1'
The import command is : impdp dabimp/dabimp directory=my_dir dumpfile=dan.dmp full=y table_exists_action=replace
Can U help me?