LOB OBJECTS APPEAR TO BE LOST AFTER THE Export/import PROCESSES (Doc ID 1595391.1)

Last updated on NOVEMBER 13, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Numerous LOB objects appear to be lost after export/import.

In our example, after the export/import process 247 LOB related objects are lost according with a select count(*) on obj object.

In source database there are 676 objects lob type

select object_type, count(*)
from obj
group by object_type
order by object_type;

OBJECT_TYPE COUNT(*)
-------------------------------
LOB                   676

The target database where the import was executed has the same version as the source database.
Here is the select on obj after the import:

SQL> select object_type, count(*)
from obj
group by object_type
order by object_type;

OBJECT_TYPE COUNT(*)
------------------- ----------
LOB                     429

During export/import process 247 LOB objects were lost, but the import did not report any kind of error.

Changes

 No changes

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