LOB data segments not all created on import/remap schema?
I have a 11.2.0.3 Oracle RAC database, currently running one instance on a shared cluster (Linux).I want to copy all contents on one schema to another.
I used datapump to export a schema, this completed with no errors.
I used datapump to import to a new schema using remap_schema. I did not use remap_tablespace because there was space in the original tablespace for a copy.
The import completed with some warnings on view compilation, but no errors.
On checking the result, the original schema was 88GB in size (sum of bytes from dba_segments for that schema) but the new remapped schema is only 40GB.
I used datapump to export a schema, this completed with no errors.
I used datapump to import to a new schema using remap_schema. I did not use remap_tablespace because there was space in the original tablespace for a copy.
The import completed with some warnings on view compilation, but no errors.
On checking the result, the original schema was 88GB in size (sum of bytes from dba_segments for that schema) but the new remapped schema is only 40GB.
0