Import the tables to a different tablespace

    版本為 04:27, 27 Nov 2024

    到這個版本。

    返回到 版本存檔.

    查閱目前版本

    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
    
    #> sqlplus mytest/mypass @idx_WIN_FDC_CDB.sql.ok | tee idx_WIN_FDC_CDB.sql.ok.log 

    Import entire tables

    Powered by MindTouch Core