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).
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading