filesystem_like_logging is not in ddl of table [message #662876] |
Mon, 15 May 2017 00:00 |
|
chad_2000
Messages: 23 Registered: February 2017
|
Junior Member |
|
|
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.
|
|
|
|
|
|
Re: filesystem_like_logging is not in ddl of table [message #662895 is a reply to message #662876] |
Mon, 15 May 2017 05:52 |
Solomon Yakobson
Messages: 3285 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
From Oracle docs:
For SecureFiles LOBs, the following applies:
The NOLOGGING setting is converted internally to FILESYSTEM_LIKE_LOGGING.
The LOGGING setting is similar to the data journaling of file systems.
Both the LOGGING and FILESYSTEM_LIKE_LOGGING settings provide a complete transactional file system.
SY.
|
|
|
Re: filesystem_like_logging is not in ddl of table [message #662897 is a reply to message #662895] |
Mon, 15 May 2017 06:48 |
|
chad_2000
Messages: 23 Registered: February 2017
|
Junior Member |
|
|
Quote:You'll have to read the doc's. I think I may have got it wrong.
Ok.Thank you so much.
Quote:
From Oracle docs:
For SecureFiles LOBs, the following applies:
The NOLOGGING setting is converted internally to FILESYSTEM_LIKE_LOGGING.
The LOGGING setting is similar to the data journaling of file systems.
Both the LOGGING and FILESYSTEM_LIKE_LOGGING settings provide a complete transactional file system.
SY.
Thank you so much.
|
|
|