Home » RDBMS Server » Server Utilities » Data Pump good as it sound's ?
icon5.gif  Data Pump good as it sound's ? [message #199856] Thu, 26 October 2006 08:08 Go to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

This is what oracle says:"
Data Pump Export and Import utilities are typically much faster than the original Export and Import Utilities. A single thread of Data Pump Export is about twice as fast as original Export, while Data Pump Import is 15-45 times fast than original Import.

Data Pump jobs can be restarted without loss of data, whether or not the stoppage was voluntary or involuntary.

Data Pump jobs support fine-grained object selection. Virtually any type of object can be included or excluded in a Data Pump job.

Data Pump supports the ability to load one instance directly from another (network import) and unload a remote instance (network export)."

I have no experince using this yet, so anyone.
Is it as good as it sound's ? Would be nice to here some input from
you guys.

Cheers

[Updated on: Thu, 26 October 2006 08:09]

Report message to a moderator

Re: Data Pump good as it sound's ? [message #199863 is a reply to message #199856] Thu, 26 October 2006 08:26 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

1. create directory ----
sql> conn / as sysdba
sql>create directory "data" as 'c:\';***************************
2. grant read, write privs. to exp or imp users.
sql>grant read , write on directory data to scott;
sql>grant read , write on directory data to tester;

*********************************************
3.conn imp or exp user
sql>conn scott/tiger
*********************************
SQL> host expdp scott/tiger directory=data dumpfile=eg.dmp tables=avgsal
Export: Release 10.1.0.2.0 - Production on Wednesday, 25 October, 2006 19:14Copyright (c) 2003, Oracle.
All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsStarting
"SCOTT"."SYS_EXPORT_TABLE_01": scott/******** directory=data dumpfile=eg.dmp tables=avgsalEstimate in progress using BLOCKS method...Processing object type TABLE_EXPORT/TABLE/TBL_TABLE_DATA/TABLE/TABLE_DATATotal estimation using BLOCKS method: 64 KBProcessing object type TABLE_EXPORT/TABLE/TABLEProcessing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS. . exported "SCOTT"."AVGSAL" 5.312 KB 5 rowsMaster table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is: C:\EG.DMPJob "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 19:15
*******************************************
SQL> drop table avgsal purge;
Table dropped.
***********************************
SQL> host impdp tester/tester directory=data dumpfile=eg.dmp
Import: Release 10.1.0.2.0 - Production on Wednesday, 25 October, 2006 19:16Copyright (c) 2003, Oracle.
All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsMaster table "TESTER"."SYS_IMPORT_FULL_01" successfully loaded/unloadedStarting "TESTER"."SYS_IMPORT_FULL_01": tester/******** directory=data dumpfile=eg.dmpProcessing object type TABLE_EXPORT/TABLE/TABLEProcessing object type TABLE_EXPORT/TABLE/TBL_TABLE_DATA/TABLE/TABLE_DATA. . imported "SCOTT"."AVGSAL" 5.312 KB 5 rowsProcessing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSJob "TESTER"."SYS_IMPORT_FULL_01" successfully completed at 19:16SQL>
note : cmd>impdp help=y
cmd> expdp help=y

see doc. for more
infohttp://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm

[Updated on: Thu, 26 October 2006 08:33]

Report message to a moderator

Re: Data Pump good as it sound's ? [message #199866 is a reply to message #199863] Thu, 26 October 2006 08:52 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Thnx for the input.

So your answer is yes then I guess Wink
Re: Data Pump good as it sound's ? [message #199876 is a reply to message #199866] Thu, 26 October 2006 09:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Data Pump good as it sound's
Yes.
Apart from the facts you have already listed, there are many more goodies. The doc or any book will list them in detail.
I like prefer the API features. Very flexible.
Re: Data Pump good as it sound's ? [message #203312 is a reply to message #199856] Tue, 14 November 2006 14:29 Go to previous messageGo to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member

The given link is not working. infohttp://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm

Can anyone provide the correct link.
Re: Data Pump good as it sound's ? [message #203313 is a reply to message #203312] Tue, 14 November 2006 14:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No surprises. Just remove those unwanted thingies before 'http://...'
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm
Re: Data Pump good as it sound's ? [message #203364 is a reply to message #203313] Tue, 14 November 2006 22:24 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi mahesh

see doc. for more
info
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm


more info http:// it mixed ...


regards
Taj.
Re: Data Pump good as it sound's ? [message #203483 is a reply to message #203364] Wed, 15 November 2006 04:31 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> hi mahesh ....

I understand that. It was @raviganti who was asking about the broken link Smile
Previous Topic: Importing full database from the exported backup
Next Topic: exporting from 10.1.0.2 , importing into 10.1.0.3
Goto Forum:
  


Current Time: Sun Dec 04 10:36:39 CST 2016

Total time taken to generate the page: 0.10577 seconds