Solved

want to use expdp/impdp instead of exp/imp

Posted on 2011-03-16
3
961 Views
Last Modified: 2012-05-11
Hi,
I want to use expdp/impdp instead of exp/imp as I came to know that its pretty fast. Due to very busy schedule I want to take you guys help that in having equivalent of the below exp/imp to convert in expdp/impdp

exp system/****@conn file=d:\exp.dmp log=d:\exp.log consistent=y owner=abcd

imp system/****@conn file='d:\exp.dmp' log='d:\imp.log' fromuser=abcd touser=abcd commit=Y
0
Comment
Question by:baberamin
3 Comments
 
LVL 6

Expert Comment

by:tangchunfeng
ID: 35147578
expdp hr/hr DIRECTORY=dpump_dir1 NETWORK_LINK=source_database_link DUMPFILE=network_export.dmp
http://www.remote-dba.net/oracle_10g_new_features/network_link.htm

impdp admin2/market TABLES=customers,sales DIRECTORY=dpump1  NETWORK_LINK=chicago
http://www.techrepublic.com/article/import-data-via-a-network-link-in-oracle-10g/6132883
0
 
LVL 7

Accepted Solution

by:
Piloute earned 500 total points
ID: 35148174
Tang,

1) If you want to use a specific directory as stated, you must create it first.
Syntax is : create or replace directory <directory_name> as <directory_path>;

2) Export and import directories are the same in baberamin's request. So should it be in your example.

3) baberamin seems to want also logs. The parameter LOGFILE=<file_name> must be appended to the export and to the import.

baberamin,

I strongly suggest you to have a look at the DataPump doc here : http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm , since it is easy to read & to understand for someone who actually uses the "old" export/import features.

It will allow you to realize that you can use new features to fasten up operations (since it seems this is your need) by using parallelism (parameter PARALLEL=<number>) for example...

Cheers,
P
0
 

Author Comment

by:baberamin
ID: 35174189
Thanks.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

785 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