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.