配置Oracle stream（8）
4.11 表中插入一行数据
主数据库
SQL> INSERT INTO tttclob VALUES(1,'clob_test');
1 row inserted
SQL> commit;
Commit complete
从数据库
SQL> SELECT * FROM tttclob;
ID MEMO
---------- --------------------------------------------
1 clob_test
4.12 创建Type测试
主数据库
SQL> CREATE or REPLACE TYPE ttttype;
2 /
Type created
从数据库
SQL> SELECT * FROM user_typesWHERE type_name='TTTTYPE';
TYPE_NAME TYPE_OID TYPECODE
ATTRIBUTES METHODS PREDEFINED INCOMPLETE FINAL INSTANTIABLE
SUPERTYPE_OWNER SUPERTYPE_NAME
LOCAL_ATTRIBUTES LOCAL_METHODS TYPEID
------------------------------ -------------------------------- ------------------------------ ---------- ----------
---------- ---------- ----- ------------ ------------------------------ ------------------------------ ----------------
------------- --------------------------------
TTTTYPE 1B36AAF10DA8301DE040A8C0289A77B4 OBJECT
0 0 NO YES YES YES
4.13 删除Type测试
主数据库
SQL> DROP TYPE ttttype;
Type dropped
从数据库
SQL> SELECT * FROM user_typesWHERE type_name='TTTTYPE';
TYPE_NAME TYPE_OID TYPECODE
ATTRIBUTES METHODS PREDEFINED INCOMPLETE FINAL INSTANTIABLE
SUPERTYPE_OWNER SUPERTYPE_NAME
LOCAL_ATTRIBUTES LOCAL_METHODS TYPEID
------------------------------ -------------------------------- ------------------------------ ---------- ----------
---------- ---------- ----- ------------ ------------------------------ ------------------------------ ----------------
------------- --------------------------------