On 19c, DEFAULT_VALUE for DB_SECUREFILE is PERMITTED, when it should be PREFERRED (Doc ID 2916244.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

On 19c, the default value for the DB_SECUREFILE parameter is PERMITTED when it should be PREFERRED, per the Oracle documentation:

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DB_SECUREFILE.html#GUID-6F7C5E21-3929-4AB1-9C72-1BB9BDDB011F
Database Reference, Release 19

1.96 DB_SECUREFILE

DB_SECUREFILE specifies whether to treat LOB files as SecureFiles.

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

Modifiable in a PDB Yes

Basic No

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.