Created a partitioned table with LOB columns. These LOBs are stored as 'SECUREFILE', a new 11g feature. When looking at the script in Schema Browser it is missing the 'STORE AS SECUREFILE'. It only shows 'STORE AS'. If this script is used to recreate the table, the LOBs are being created as 'STORE AS BASICFILE'
Example:
create table using following script:
-----------------------------------------
CREATE TABLE tickets (
tkt_id NUMBER
,description VARCHAR2(30)
,submit_dtm TIMESTAMP
,status VARCHAR2(8)
,document BLOB
,scrnimg BLOB
)
LOB(document)
STORE AS SECUREFILE (TABLESPACE ASSM_TBSPCE)
,LOB(scrnimg)
STORE AS SECUREFILE (TABLESPACE ASSM_TBSPCE)
PARTITION BY LIST (status) (
PARTITION sts_open
VALUES ('OPEN')
,PARTITION sts_pending
VALUES ('PENDING')
,PARTITION sts_closed
VALUES ('CLOSED')
,PARTITION sts_other
VALUES (DEFAULT)
)
;
Script generated by Toad:
-------------------------------
CREATE TABLE TICKETS
(
TKT_ID NUMBER,
DESCRIPTION VARCHAR2(30 BYTE),
SUBMIT_DTM TIMESTAMP(6),
STATUS VARCHAR2(8 BYTE),
DOCUMENT BLOB,
SCRNIMG BLOB
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
PARTITION BY LIST (STATUS)
(
PARTITION STS_OPEN VALUES ('OPEN')
LOGGING
NOCOMPRESS
TABLESPACE USERS
LOB (DOCUMENT) STORE AS ***** 'SECUREFILE' is missing *******
( TABLESPACE ASSM_TBSPCE
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
STORAGE (
INITIAL 104K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 4
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)...
WORKAROUND
none
STATUS
Waiting for fix in a future release of Toad for Oracle
