Skip to Main Content
  • Questions
  • filesystem_like_logging is not in ddl of table

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Tae.

Asked: May 16, 2017 - 12:15 pm UTC

Last updated: May 17, 2017 - 4:01 pm UTC

Version: Oracle 12.1.0.2

Viewed 1000+ times

You Asked

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.

and Connor said...

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.


Is this answer out of date? If it is, please let us know via a Comment

More to Explore

CLOB/BLOB/etc

Complete documentation on Securefiles and Large Objects here