Solved

Translate a dump file from expdp to exp

Posted on 2006-11-16
7
540 Views
Last Modified: 2012-08-13
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?
0
Comment
Question by:DanBenedek
  • 4
  • 3
7 Comments
 
LVL 48

Expert Comment

by:schwertner
ID: 17954146
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
 

Author Comment

by:DanBenedek
ID: 17954330
I have a little question

Where should i put the expsch.par file?
0
 

Author Comment

by:DanBenedek
ID: 17954402
Thanks i managed to solve my problem without the parfile. I just put the parameters in the command line.
0
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
LVL 48

Expert Comment

by:schwertner
ID: 17954460
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
 

Author Comment

by:DanBenedek
ID: 17954470
I asked WHERE not WHAT
0
 
LVL 48

Accepted Solution

by:
schwertner earned 75 total points
ID: 17954812
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
 

Author Comment

by:DanBenedek
ID: 18107063
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious sideā€¦
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question