LOB tables missing with exp/imp move of schema

I have a problem when moving a schema using exp/imp. After import, the tables with LOBs are missing.

I have a problem when moving a schema using exp/imp. After import, the tables with LOBs are missing (trying to import to a non-existing tablespace). How can I change the LOB tables to the original tablespace? Is there any problem in changing index name starting with Sys_ to a new name?

Also even if my default tablespace for a user schema is username_tbl, after import, the tables are imported to another tablespace (the tablespace name with exported username).

I ran into this same issue myself. I had to create a tablespace in the destination database that was the same tablespace name where the LOB segments reside in the source database. Then I reran my import. For some reason, Oracle does not create the LOB segments in the user's default tablespace. Another option is to precreate the table with the LOB segments in the correct tablespace. Then import with IGNORE=Y.

Dig Deeper on Oracle database administration

Data Management
Business Analytics
SearchSAP
TheServerSide.com
Data Center
Content Management
HRSoftware
Close