指定LOB参数RETENTION,PCTVERSION的一个小BUG(二)

SQL> select OBJ#,bitand(flags,32) from lob$ where obj# in (select object_id from dba_objects where owner='LYN' and object_name in ('WATER1','WATER2'));

OBJ# BITAND(FLAGS,32)
---------- ----------------
10356 0 -- 0代表用的pctversion
10356 32 – 32 代表用的retention
10351 32
10351 32

CREATE TABLE AS ：

SQL> create table lyn.water3 as select * from lyn.water1 where 1=2;

Table created.

SQL> select dbms_metadata.get_ddl('TABLE','WATER3','LYN') from dual;

DBMS_METADATA.GET_DDL('TABLE','WATER3','LYN')
--------------------------------------------------------------------------------

CREATE TABLE "LYN"."WATER3"
( "ID" NUMBER,
"PIC" BLOB,
"DES" CLOB
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NO
COMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS
2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "LOBTB"

DBMS_METADATA.GET_DDL('TABLE','WATER3','LYN')
--------------------------------------------------------------------------------
LOB ("PIC") STORE AS (
TABLESPACE "LOBTB" ENABLE STORAGE IN ROW CHUNK 8192 PCTV
ERSION 10
NOCACHE LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_PO
OL DEFAULT))
LOB ("DES") STORE AS (
TABLESPACE "LOBTB" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 1
0
NOCACHE LOGGING

DBMS_METADATA.GET_DDL('TABLE','WATER3','LYN')
--------------------------------------------------------------------------------
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTE
NTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAU
LT))

SQL> select OWNER,TABLE_NAME,SEGMENT_NAME,PCTVERSION,RETENTION from dba_lobs where owner='LYN' AND table_name like 'WATER%';

OWNER TABLE_NAME SEGMENT_NAME PCTVERSION RETENTION
---------- -------------------- ------------------------------ ---------- ----------
LYN WATER1 SYS_LOB0000010351C00002$$ 1800
LYN WATER1 SYS_LOB0000010351C00003$$ 1800
LYN WATER2 WATER2_PIC 5
LYN WATER2 WATER2_DES 1800
LYN WATER3 SYS_LOB0000010361C00002$$ 10 -- 可以看到不是RETENTION方式了
LYN WATER3 SYS_LOB0000010361C00003$$ 10
LYN WATERFALLS SYS_LOB0000010268C00002$$ 1800
LYN WATERFALLS SYS_LOB0000010268C00003$$ 1800
LYN WATERFALLS SYS_LOB0000010268C00004$$ 1800

9 rows selected.

SQL> select OBJ#,bitand(flags,32) from lob$ where obj# in (select ob