My Oracle Support Banner

ORA-43853 When Creating Temporary Table Contains SECUREFILE LOBs In Temporary Tablespace In 12c (Doc ID 2323564.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1 to 12.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


When you try to create a temporary table contains SECUREFILE LOBs in the temporary tablespace,
if it is on 11gR2 database, the temporary table can be created without any error, but actually the columns are BASICFILE LOBs rather than SECUREFILE LOBs.

While if you do it on 12c database, you will get the error ORA-43853 and the table will not be created.



 Upgrade database to 12c.


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.