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 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

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.

 

Changes

 Upgrade database to 12c.

Cause

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