What is the impact of this setting on the usage of SecureFiles?

Evaluate the following command:

SQL>ALTER SYSTEM SET db_securefile = ‘IGNORE’;

What is the impact of this setting on the usage of SecureFiles?

Evaluate the following command:

SQL>ALTER SYSTEM SET db_securefile = ‘IGNORE’;

What is the impact of this setting on the usage of SecureFiles?

A.
It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB.

B.
It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB.

C.
It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB.

D.
It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile.



Leave a Reply 0

Your email address will not be published. Required fields are marked *