Home » SQL & PL/SQL » SQL & PL/SQL » filesystem_like_logging is not in ddl of table (oracle 12.1.0.2,Windows Server 2014)
filesystem_like_logging is not in ddl of table [message #662876] Mon, 15 May 2017 00:00 Go to next message
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 #662878 is a reply to message #662876] Mon, 15 May 2017 01:16 Go to previous messageGo to next message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
filesystem_like_logging is only for backward compatibility with basicfile LOBs, so it isn't stored. Same as pctversion.
Re: filesystem_like_logging is not in ddl of table [message #662885 is a reply to message #662876] Mon, 15 May 2017 02:52 Go to previous messageGo to next message
chad_2000
Messages: 23
Registered: February 2017
Junior Member
Quote:
filesystem_like_logging is only for backward compatibility with basicfile LOBs, so it isn't stored. Same as pctversion.

Thank you for your reply, as always helpful.
So if filesystem_like_logging is set for secure lob column , is logging done based on filesystem_like_logging?
Re: filesystem_like_logging is not in ddl of table [message #662886 is a reply to message #662885] Mon, 15 May 2017 02:56 Go to previous messageGo to next message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
You'll have to read the doc's. I think I may have got it wrong.
Re: filesystem_like_logging is not in ddl of table [message #662895 is a reply to message #662876] Mon, 15 May 2017 05:52 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3273
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 Go to previous message
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.
Previous Topic: Taking time from current day/month/year 06:00:00 to sysdate(Current Time)
Next Topic: Loading Data into multiple tables
Goto Forum:
  


Current Time: Fri Apr 19 21:47:37 CDT 2024