SECUREFILE Column From DBA_LOBS View Is Returning Wrong Result (Doc ID 2590583.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

SECUREFILE column from DBA_LOBS view is returning wrong result.

Created a simple table with 2 LOB columns without explicitly using the SECUREFILE option for the LOB columns, and yet when querying the DBA_LOBS view, the SECUREFILE column is returning value 'YES' for those 2 LOB columns.

Below is the DDL for the table:

CREATE TABLE LOBT1 ( PKCOL number(10) not null, BLOB_COL blob null, CLOB_COL clob null, primary key( PKCOL )) tablespace users;

Below is the query against DBA_LOBS for the table LOBT1:

select column_name, securefile from dba_lobs where table_name = 'LOBT1';

COLUMN_NAME               SEC
--------------------      -------
BLOB_COL                     YES
CLOB_COL                     YES

Changes

Cause

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