以下为导出800万行普通表的测试,导出格式为expdp,耗时20多秒。
GDUL> desc andy.t_big_table
object_id: 77494, dataobj#: 77494, cluster tab#: 0
segment header: (ts#: 4, rfile#: 4, block#: 14074))
Name Null? Type
-------------------- --------------- --------------
OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(30)
GDUL> unload table andy.t_big_table
2016-12-06 13:20:43 unloading table "ANDY"."T_BIG_TABLE"...
2016-12-06 13:21:05 unloaded 8099838 rows