GDUL产品特性

支持绝大多数表及列类型

GDUL支持绝大多数表及列类型，具体支持如下：

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

示例如下：

普通列类型

terminal

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)

terminal

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.

CLOB/BLOB/压缩LOB

terminal

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.

terminal

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.

terminal

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.

IOT

terminal

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.