 Data Pump good as it sound's ? [message #199856] |
Thu, 26 October 2006 08:08  |
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  |
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
