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 administration
Related Q&A from Brian Peasland
Readers ask SearchOracle.com expert Brian Peasland where they can find learning materials for becoming a better Oracle database administrator. Continue Reading
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