Database Error Messages

ORA-39252

Importing a SECUREFILE LOB with metadata or archived SECUREFILE LOB into a BASICFILE LOB is not valid.

Cause

Attempted to import a SECUREFILE LOB that contained metadata or was archived at the time of export into a BASICFILE LOB.


Action

Perform the following actions.

  1. Import the SECUREFILE LOB into a different table.
  2. Use DBMS_LOB.ARCHIVE_GET on any archived SECUREFILE LOBs.
  3. Use INSERT AS SELECT to migrate the SECUREFILE LOB data to the BASICFILE LOB.