oracle下面换schema过程记录

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