Hi,
A table with blob column and filesystem_like_logging feature is created using following script:
create table contracts_sec_fs
(
contract_id number(12),
contract_name varchar2(80),
file_size number,
orig_file blob
)
tablespace users
lob (orig_file)
store as securefile
(
tablespace users
enable storage in row
chunk 8192
pctversion 20
nocache
filesystem_like_logging
)
But filesystem_like_logging is not in ddl of table( also in toad, filesystem_like_logging feature is unchecked in properties of blob column )
CREATE TABLE "CHAD"."CONTRACTS_SEC_FS"
( "CONTRACT_ID" NUMBER(12,0),
"CONTRACT_NAME" VARCHAR2(80 BYTE),
"FILE_SIZE" NUMBER,
"ORIG_FILE" BLOB
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
TABLESPACE "USERS"
LOB ("ORIG_FILE") STORE AS SECUREFILE (
TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192
NOCACHE NOLOGGING NOCOMPRESS KEEP_DUPLICATES ) ;
Any help on this would be very helpful.
Thanks in advance.
It's a little obtuse, but this is ok.
From the docs for securefiles:
"The NOLOGGING setting is converted internally to FILESYSTEM_LIKE_LOGGING."
So this is why the DDL comes out like it does.