login as sysdba
SQL>grant read, write on directory DATA_PUMP_DIR to oracle_user;
//select * from dba_directories where directory_name='DATA_PUMP_DIR';
default: $ORACLE_HOME/rdbms/log
$expdp shfedc1/shfedc1 schemas=SHFEDC1 directory=DATA_PUMP_DIR dumpfile=shfedc1.dmp
login as sysdba
SQL>drop user shfedc1 cascade;
for oracle 10g:
$impdp \"sys/sys as sysdba\" schemas=SHFEDC1 remap_schema=shfedc1:felab directory=DATA_PUMP_DIR dumpfile=shfedc1.dmp
login as sysdba
SQL>alter user felab identified by felab;
for oracle 11g:
login as sysdba and then create user felab and grant resource,connect to felab
and then
$impdp \"sys/sys as sysdba\" schemas=SHFEDC1 remap_schema=shfedc1:felab directory=DATA_PUMP_DIR dumpfile=shfedc1.dmp
值得参考的文章:
http://blog.zdnet.com.cn/html/80/289380-2884327.html
阅读(991) | 评论(1) | 转发(0) |