Solved

Translate a dump file from expdp to exp

Posted on 2006-11-16
7
533 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 47

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 47

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 47

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now