Q
Problem solve Get help with specific problems with your technologies, process and projects.

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 backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close