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?
DanBenedekAsked:
Who is Participating?
 
schwertnerCommented:
In an directory that you can access.
In windows you can dedicate a directory to export and import and use it.
I Linux do the same, but CHOWN to the user'oracle' this directory.
0
 
schwertnerCommented:
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.
0
 
DanBenedekAuthor Commented:
I have a little question

Where should i put the expsch.par file?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
DanBenedekAuthor Commented:
Thanks i managed to solve my problem without the parfile. I just put the parameters in the command line.
0
 
schwertnerCommented:
This:

USERID='sys/manager@alias as sysdba'
DIRECTORY=my_dir
DUMPFILE=dan.dmp
LOGFILE=dan.log
FULL=y
CONTENT=all
table_exists_action=replace
0
 
DanBenedekAuthor Commented:
I asked WHERE not WHAT
0
 
DanBenedekAuthor Commented:
I didn't want to give you all the points becase U don't deserve them because U didn't answer my question WHERE should I put the file
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.