- 论坛徽章:
- 0
|
我用传输表空间步骤如下:
在旧库,在ts_test02有一个用户test02,用户test02含有表t_transport和索引ind_transport:
执行如下命令:
alter tablespace ts_test02 read only;
exp \"sys/test@testinst as sysdba\" tablespaces=ts_test02 transport_tablespace=y file=exp_ts_test02.dmp
把数据文件test-02.dbf传到新机器。
在新库执行如下命令:
imp \"sys/test@testinst as sysdba\" tablespaces=ts_test02 transport_tablespace=y file=exp_ts_test02.dmp datafiles='test-02.dbf'
提示错误信息如下:
Export file created by EXPORT:V10.02.01 via conventional path
About to import transportable tablespace(s) metadata...
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing SYS's objects into SYS
. importing SYS's objects into SYS
IMP-00017: following statement failed with ORACLE error 29342:
"BEGIN sys.dbms_plugts.checkUser('test02'); END;"
IMP-00003: ORACLE error 29342 encountered
ORA-29342: user test02 does not exist in the database
ORA-06512: at "SYS.DBMS_PLUGTS", line 1895
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully
不知道该如何解决了 |
|