Solved

Translate a dump file from expdp to exp

Posted on 2006-11-16
7
541 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: 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!

 
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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to take different types of Oracle backups using RMAN.

695 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