My Oracle Support Banner

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

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


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




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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