asked on

Translate a dump file from expdp to exp

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?

schwertner

I think the error is caused by

dabimp/dabimp

This is not the DBA!

To do successful Import with Data Pump

you have to work as SYS user:

File expsch.par:

USERID='sys/manager@alias as sysdba'
DIRECTORY=PUMP
DUMPFILE=010f_pump.dmp
LOGFILE=expsch.log
FULL=y
CONTENT=all

Run the parameter file so
impdp parfile=expsch.par

Please modify the file according your needs.

Possibly you will have troubles with the directory and the tablespaces.

connect system/manager@o10f
create directory pump as '/u01/app/oracle/product/10.2.0/m/pump_directory';
grant read,write on directory pump to sys;

If you experience troubles with the tablespaces please report.

DanBenedek

ASKER

I have a little question

Where should i put the expsch.par file?

DanBenedek

ASKER

Thanks i managed to solve my problem without the parfile. I just put the parameters in the command line.

schwertner

This:

USERID='sys/manager@alias as sysdba'
DIRECTORY=my_dir
DUMPFILE=dan.dmp
LOGFILE=dan.log
FULL=y
CONTENT=all
table_exists_action=replace

DanBenedek

ASKER

I asked WHERE not WHAT

ASKER CERTIFIED SOLUTION