我已经成功地将11g转储导入到我的本地12c安装中,如下所示:
-- CREATE DATA_DUMP_DIR and give priviledges to SYSTEM
CREATE DIRECTORY main_data_pump_dir as 'C:adeaime_voracleadminseeddatadpdump';
GRANT READ, WRITE ON DIRECTORY main_data_pump_dir TO SYSTEM;
impdp system/Oracle_1@pdborcl directory=main_data_pump_dir dumpfile=myshema.dmp nologfile=Y
现在我正试图这样导出:
expdp myschema dumpfile=main_data_pump_dir:myschema.dmp reuse_dumpfiles=y nologfile=Y
或者这个:
expdp myschema@pdborcl dumpfile=main_data_pump_dir:myschema.dmp reuse_dumpfiles=y nologfile=Y
但我似乎无法让它发挥作用。我需要授权给myschema写信吗?
这最终对我有效:
expdp System/Oracle_1@pdborcl schemas=myschema dumpfile=main_data_pump_dir:myschema.dmp nologfile=yes reuse_dumpfiles=yes