GDUL产品特性

支持绝大多数表及列类型

• 支持普通表、压缩表、IOT、分区表，Cluster表等。
• 支持各类基本类型和LOB/SecureFile列类型，支持压缩格式存储的SecureFile类型LOB。尚不支持去重和加密。

1. 普通列类型

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.

2. CLOB/BLOB/压缩LOB

GDUL> unload table andy.t_secure_lob

2016-12-06 13:48:21 unloading table "ANDY"."T_SECURE_LOB"...
2016-12-06 13:48:21 unloaded 6 rows.

GDUL> unload table andy.T_SECURE_LOB_COMPRESS_HIGH

2016-12-06 13:48:38 unloading table "ANDY"."T_SECURE_LOB_COMPRESS_HIGH"...
2016-12-06 13:48:38 unloaded 5 rows.

GDUL> unload table andy.t_blob

2016-12-06 13:49:21 unloading table "ANDY"."T_BLOB"...
2016-12-06 13:49:21 unloaded 4 rows.

3. IOT

GDUL> unload table andy.t_iot

2016-12-06 13:48:51 unloading table "ANDY"."T_IOT"...
2016-12-06 13:48:51 unloaded 2 rows.