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:

#> 

#> 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