?
Solved

want to use expdp/impdp instead of exp/imp

Posted on 2011-03-16
3
Medium Priority
?
980 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
[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
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 2000 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

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to recover a database from a user managed backup
Suggested Courses

770 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