ORA-39252: Importing a SecureFile LOB with metadata or archived SecureFile LOB

曾春华

ORA-39252: Importing a SecureFile LOB withmetadata or archived SecureFile LOB

into a BasicFile LOB is not allowed

Cause: An attempt was made to importa SecureFile LOB that contained metadata

or was archived at the time of export into a BasicFileLOB.

Action: Perform the import into adifferent table, perform DBMS_

LOB.ARCHIVE_GET on any archived SecureFile LOBs, and thenuse INSERT AS

SELECT to migrate the SecureFile LOB data to theBasicFile LOB.