By
Published: 15 Aug 2007
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
In this expert answer, Brian Peasland explains how to call a stored procedure inside user-defined functions in Oracle Database.
Continue Reading
One reader asks how he can make a copy of his Oracle Database but not have any data in it, for test purposes.
Continue Reading
Learn how to add disk to ASM diskgroup with two-way mirroring and how to specify a failgroup in this tip from Oracle expert Brian Peasland.
Continue Reading