How Oracle EXPDP and IMPDP automatically use resumable features

Compared to EXPDP, IMPDP and exp, IMP found that the former did not have the Resumable function, the test found that EXPDP and IMPDP automatically used the resumable characteristics

C:>EXPDP TEST/TEST@ORCL directory=dir_temp dumpfile=t.dmp tables=t2

Export:release 10.2.0.1.0-production on Thursday, 03 September, 2009 18:41:41

Copyright (c) 2003, +, Oracle. All rights reserved.

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

Start "TEST". Sys_export_table_01 ": test/******** @orcl directory=dir_temp DUMPFI

Le=t.dmp Tables=t2

Using the BLOCKS method to estimate ...

Working with Object Types Table_export/table/table_data

Total estimate using the BLOCKS method: MB

Working with Object Types table_export/table/table

Working with Object Types Table_export/table/statistics/table_statistics

. . The "TEST" was exported. T2 "18.84 MB 759316 Lines

The primary table ' TEST ' was successfully loaded/unloaded. Sys_export_table_01 "

******************************************************************************

TEST. The set of dump files for sys_export_table_01 is:

C:bakt. DMP

The job "TEST". Sys_export_table_01 "completed successfully at 18:42:11

C:>

--==================================

Sql> Select file_id,file_name,tablespace_name,bytes/1024/1024 m, autoextensible

From Dba_data_files;

file_id file_name tablespace M AUT

---------- ------------------------------ ---------- ---------- ---

1 c:tempsystem01. DBF SYSTEM YES

9 c:tempusers. DBF USERS 5 NO

6 C:tempundotbs02. DBF UNDOTBS2 NO

5 c:temptest. DBF TEST YES

3 c:tempsysaux01. DBF Sysaux YES

--==================================

C:>IMPDP TEST/TEST@ORCL directory=dir_temp dumpfile=t.dmp remap_schema= (TEST:SC

Ott) remap_tablespace= (test:users)

Import:release 10.2.0.1.0-production on Thursday, 03 September, 2009 18:48:42

Copyright (c) 2003, +, Oracle. All rights reserved.

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

The primary table ' TEST ' was successfully loaded/unloaded. Sys_import_full_01 "

Start "TEST". Sys_import_full_01 ": test/******** @orcl directory=dir_temp Dumpfil

E=t.dmp remap_schema= (Test:scott) remap_tablespace= (test:users)

Working with Object Types table_export/table/table

Working with Object Types Table_export/table/table_data

........ This place hang live.

--================================

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

View Dba_resumable found above IMPDP indeed suspended:

Sql> Select Status,timeout,name,error_parameter1,error_parameter2,error_paramete

R3,error_parameter4 from Dba_resumable;

STATUS TIMEOUT NAME Error Error Error

--------- ---------- ------------------------------ ----- ----- ----- -----

NORMAL 7200 TEST. Sys_import_full_01

Suspended 7200 TEST. sys_import_full_01.1 SCOTT T2 128 USERS

sql> ALTER DATABASE datafile 9 autoextend on;

The database has changed.

Sql>

--==========================

DataFile 9 can be extended automatically after IMPDP continues:

C:>IMPDP TEST/TEST@ORCL directory=dir_temp dumpfile=t.dmp remap_schema= (TEST:SC

Ott) remap_tablespace= (test:users)

Import:release 10.2.0.1.0-production on Thursday, 03 September, 2009 18:48:42

Copyright (c) 2003, +, Oracle. All rights reserved.