ORA-43853 When Creating Temporary Table Contains SECUREFILE LOBs In Temporary Tablespace In 12c
Last updated on NOVEMBER 06, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [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