Import the tables to a different tablespace
Oracle offers no parameter to specify a different tablespace to import data into. Objects will be re-created in the tablespace they were originally exported from. One can alter this behaviour by following procedure:
Import the dump file using INDEXFILE= option
#> imp system/oracle fromuser=WIN_FDC_CDB touser=MYTEST file=./exp_WIN_FDC_CDB.dmp log=./imp_WIN_FDC_CDB.log indexfile=./idx_WIN_FDC_CDB.sql
Edit the idexfiles against your database
indexfile: idx_WIN_FDC_CDB.sql
#> sed -e 's/^REM//g' idx_WIN_FDC_CDB.sql -e '/rows$/d' -e 's/"CDB"/"MYTEST_DB"/g' > idx_WIN_FDC_CDB.sq.ok
Import entire tables
Powered by MindTouch Core