ORA-43853 When Creating Temporary Table Contains SECUREFILE LOBs In Temporary Tablespace In 12c

(Doc ID 2323564.1)

Last updated on NOVEMBER 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1 to 12.2]
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.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms