Solved

want to use expdp/impdp instead of exp/imp

Posted on 2011-03-16
3
952 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
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.
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.

911 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