expdp測試包含有lob型別的物件
1.一般測試
ROOTDBA@ora11g>create table t_lob as select * from dba_objects where 1=2;
Table created.
Elapsed: 00:00:00.06
ROOTDBA@ora11g>create table t_char as select * from dba_objects where 1=2;
Table created.
Elapsed: 00:00:00.05
ROOTDBA@ora11g>alter table t_lob add f1_lob clob;
Table altered.
Elapsed: 00:00:00.02
ROOTDBA@ora11g>alter table t_char add f1_char varchar2(4000);
Table altered.
Elapsed: 00:00:00.02
ROOTDBA@ora11g>insert into t_lob select a.*,rpad(’rootdba’,3000,’ rootdba ‘) from dba_objects a ;
17711 rows created.
Elapsed: 00:00:37.33
ROOTDBA@ora11g>commit;
Commit complete.
Elapsed: 00:00:00.01
ROOTDBA@ora11g>insert into t_char select a.*,rpad(’rootdba’,3000,’ rootdba ‘) from dba_objects a ;
17711 rows created.
Elapsed: 00:00:26.14
ROOTDBA@ora11g>commit;
Commit complete.
Elapsed: 00:00:00.07
ROOTDBA@ora11g>insert into t_lob select * from t_lob;
17711 rows created.
Elapsed: 00:01:11.82
ROOTDBA@ora11g>commit;
Commit complete.
Elapsed: 00:00:00.11
ROOTDBA@ora11g>
ROOTDBA@ora11g>
ROOTDBA@ora11g>insert into t_char select * from t_char;
17711 rows created.
Elapsed: 00:00:43.27
ROOTDBA@ora11g>commit;
Commit complete.
Elapsed: 00:00:00.05
ROOTDBA@ora11g>
ROOTDBA@ora11g>
ROOTDBA@ora11g>
ROOTDBA@ora11g>
ROOTDBA@ora11g>insert into t_char select * from t_char;
35422 rows created.
Elapsed: 00:00:58.76
ROOTDBA@ora11g>commit;
Commit complete.
Elapsed: 00:00:00.10
ROOTDBA@ora11g>
ROOTDBA@ora11g>
oracle@dbatest1:/u01/dmpdir #time expdp rootdba/abc123 directory=dmpdir dumpfile=t_lob.dmp tables=t_lob
Export: Release 11.2.0.1.0 – Production on Wed Sep 30 13:53:48 2009
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
With the Partitioning, Data Mining and Real Application Testing options
Starting “ROOTDBA”.”SYS_EXPORT_TABLE_01″: rootdba/******** directory=dmpdir dumpfile=t_lob.dmp tables=t_lob
Estimate in progress using BLOCKS method…
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 285 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported “ROOTDBA”.”T_LOB” 206.0 MB 35422 rows
Master table “ROOTDBA”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for ROOTDBA.SYS_EXPORT_TABLE_01 is:
/u01/dmpdir/t_lob.dmp
Job “ROOTDBA”.”SYS_EXPORT_TABLE_01″ successfully completed at 13:54:43
real 0m57.580s
user 0m0.026s
sys 0m0.019s
oracle@dbatest1:/u01/dmpdir #time expdp rootdba/abc123 directory=dmpdir dumpfile=t_char.dmp tables=t_char
Export: Release 11.2.0.1.0 – Production on Wed Sep 30 14:00:03 2009
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
With the Partitioning, Data Mining and Real Application Testing options
Starting “ROOTDBA”.”SYS_EXPORT_TABLE_01″: rootdba/******** directory=dmpdir dumpfile=t_char.dmp tables=t_char
Estimate in progress using BLOCKS method…
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 280 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported “ROOTDBA”.”T_CHAR” 209.3 MB 70844 rows
Master table “ROOTDBA”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for ROOTDBA.SYS_EXPORT_TABLE_01 is:
/u01/dmpdir/t_char.dmp
Job “ROOTDBA”.”SYS_EXPORT_TABLE_01″ successfully completed at 14:00:36
real 0m33.963s
user 0m0.022s
sys 0m0.023s
2.使用exclude功能
oracle@dbatest1:/u01/dmpdir # expdp rootdba/abc123 directory=dmpdir dumpfile=rootdba.dmp schemas=rootdba EXCLUDE=TABLE:”\=\’T_LOB’”
Export: Release 11.2.0.1.0 – Production on Wed Sep 30 14:09:10 2009
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
With the Partitioning, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting “ROOTDBA”.”SYS_EXPORT_SCHEMA_01″: rootdba/********
directory=dmpdir dumpfile=rootdba.dmp schemas=rootdba
EXCLUDE=TABLE:\=\’T_LOB’
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 720.1 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/POST_TABLE_ACTION
Processing object type SCHEMA_EXPORT/TABLE/MATERIALIZED_VIEW_LOG
. . exported “ROOTDBA”.”T_CHAR” 209.3 MB 70844 rows
. . exported “ROOTDBA”.”T_P”:”P40″ 203.1 MB 11835831 rows
. . exported “ROOTDBA”.”T_P”:”P30″ 105.8 MB 6163359 rows
. . exported “ROOTDBA”.”T_P”:”P20″ 52.43 MB 3054408 rows
. . exported “ROOTDBA”.”EXP_DG” 5.460 KB 4 rows
. . exported “ROOTDBA”.”TP”:”P1″ 5.453 KB 3 rows
. . exported “ROOTDBA”.”T_MV” 5.437 KB 2 rows
. . exported “ROOTDBA”.”MLOG$_T_MV” 0 KB 0 rows
. . exported “ROOTDBA”.”TP”:”P2″ 0 KB 0 rows
. . exported “ROOTDBA”.”T_P”:”P10″ 0 KB 0 rows
. . exported “ROOTDBA”.”T_P_LIST”:”P1″ 0 KB 0 rows
. . exported “ROOTDBA”.”T_P_LIST”:”P2″ 0 KB 0 rows
Master table “ROOTDBA”.”SYS_EXPORT_SCHEMA_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for ROOTDBA.SYS_EXPORT_SCHEMA_01 is:
/u01/dmpdir/rootdba.dmp
Job “ROOTDBA”.”SYS_EXPORT_SCHEMA_01″ successfully completed at 14:10:33
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7364032/viewspace-615928/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle - LOB（大物件資料型別）Oracle物件資料型別
- 測試TOM=用PLSQL載入LOB型別資料SQL型別
- LOB型別型別
- 移動LOB型別的索引型別索引
- LONG型別遷移到LOB型別（三）型別
- LONG型別遷移到LOB型別（二）型別
- LONG型別遷移到LOB型別（一）型別
- 測試物件和測試級別物件
- 為lob型別分配extents型別
- JS中資料型別、內建物件、包裝型別物件、typeof關係JS資料型別物件
- 測試NUMBER型別的效能型別
- dbms_lob.write 測試
- expdp 遷移測試
- Oracle LOB資料型別的處理Oracle資料型別
- 常見物件-基本型別包裝類物件型別
- Oracle Lob型別儲存淺析Oracle型別
- 插入LOB物件的方法物件
- js型別測試學習JS型別
- 將lob型別的index移動到其它tablespace型別Index
- 轉：11g對LOB型別的新增功能型別
- 軟體驗收測試 常見測試報告的型別測試報告型別
- 測試Java中的long，int基本型別Java型別
- 軟體測試開發:常見測試型別概念型別
- RecyclerView 多條目型別含有多個EditTextView型別
- 敏捷開發中的7種測試型別敏捷型別
- 測試使用字串型別要注意的地方字串型別
- 路由器測試的型別和方法[轉]路由器型別
- JavaScript的型別和物件JavaScript型別物件
- 網路安全滲透測試的型別！滲透測試入門教程型別
- Android Testing學習01 介紹 測試測什麼 測試的型別Android型別
- javascript基本型別 引用型別 基本包裝型別JavaScript型別
- LOB欄位EMPTY_LOB和NULL的區別Null
- 軟體測試報告模板的型別有哪些？測試報告型別
- 金融行業的軟體測試型別細分行業型別
- 資料型別和運算子測試題資料型別
- 測試boot庫下I/O模型型別boot模型型別
- mysql中varchar型別最大長度測試MySql型別
- javascript對於值型別資料的物件包裝簡單介紹JavaScript型別物件