ORACLE PFILE SETTINGS

DB_SECUREFILE

https://docs.oracle.com/cloud/latest/db121/REFRN/refrn10290.htm#REFRN10290

Property Description

Parameter type String

Syntax DB_SECUREFILE = { NEVER | PERMITTED | PREFERRED | ALWAYS | IGNORE }

Default value PERMITTED if the COMPATIBLE initialization parameter is set to 11.2.0.1, 11.2.0.2, or 11.2.0.3, or PREFERRED if the COMPATIBLE initialization parameter 

is set to 12.0.0.0 or higher

Modifiable ALTER SESSION, ALTER SYSTEM

Basic No

DB_SECUREFILE specifies whether to treat LOB files as SecureFiles.

Values

NEVER

Any LOBs that are specified as SecureFiles are created as BasicFiles LOBs. All SecureFiles-specific storage options and features (for example, compress, encrypt, deduplicate) will cause an exception. The BasicFiles LOB defaults will be used for storage options not specified.

PERMITTED

LOBs are allowed to be created as SecureFiles.

PREFERRED

All LOBs are created as SecureFiles unless BASICFILE is explicitly specified in the LOB storage clause or the tablespace is a Manual Segment Space Management tablespace. When PREFERRED is set, cases where BASICFILE would otherwise be inherited from the partition or column level LOB storage are ignored; the LOBs will be created as SecureFiles instead.

ALWAYS

Attempts to create all LOBs as SecureFiles LOBs but creates any LOBs not in an Automatic Segment Space Managed (ASSM) tablespace as BasicFiles LOBs, unless SECUREFILE is explicitly specified. Any BasicFiles LOB storage options that are specified will be ignored and the SecureFiles LOB defaults will be used for all storage options not specified.

IGNORE

The SECUREFIL