LOB OBJECTS APPEAR TO BE LOST AFTER THE Export/import PROCESSES
(Doc ID 1595391.1)
Last updated on SEPTEMBER 09, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.1 [Release 11.2 to 12.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |