oracle 数据库导入导出方法

#exp/imp 新数据库需要建立相关用户

FEEMAN
FEEMANTMP
COTTAGE
HEUSER


#导出操作
export ORACLE_SID=firstly1
exp its/its owner=FEEMAN file=/exp/exp01/FEEMAN0929.dmp log=/exp/exp01/FEEMANexp.log
exp its/its owner=FEEMANTMP file=/exp/exp01/exp/FEEMANTMP0929.dmp log=/exp/exp01/FEEMANTMPexp.log
exp its/its owner=COTTAGE file=/exp/exp01/COTTAGE0929.dmp log=/exp/exp01/COTTAGEexp.log
exp its/its owner=HEUSER file=/exp/exp01/HEUSER0929.dmp log=/exp/exp01/HEUSERexp.log



#导入操作
export ORACLE_SID=firstly1
创建用户
sqlplus / as sysdba
create user FEEMAN identified by FEEMAN;
create user FEEMANTMP identified by FEEMANTMP;
create user COTTAGE identified by COTTAGE;
create user HEUSER identified by HEUSER;
grant dba to FEEMAN;
grant dba to FEEMANTMP;
grant dba to COTTAGE;
grant dba to HEUSER;

执行导入操作：
export ORACLE_SID=firstly1
imp system/oracle  fromuser=FEEMAN touser=FEEMAN file=/home/exp/exp01/FEEMAN0929.dmp log=/home/exp/exp01/FEEMANimp.log
imp system/oracle fromuser=FEEMANTMP touser=FEEMANTMP file=/home/exp/exp01/FEEMANTMP0929.dmp log=/home/exp/exp01/FEEMANTMPimp.log
imp system/oracle fromuser=COTTAGE touser=COTTAGE file=/home/exp/exp01/COTTAGE0929.dmp log=/home/exp/exp01/COTTAGEimp.log
imp system/oracle fromuser=HEUSER touser=HEUSER file=/home/exp/exp01/HEUSER0929.dmp log=/home/exp/exp01/HEUSERimp.log

#expdp/impdp

MOOC 
HEUSER   
POST  
CMS   
QLIB   
RESCLOUD   
PLANTATION   
SAKAI

#

导出命令：
#导出之前指定环境变量ORACLE_SID
export ORACLE_SID=secondly1
#确认环境变量正确即可执行导入导出命令
#echo $ORACLE_SID 

#建立目录
export ORACLE_SID=firstly1
sqlplus / as sysdba
create user its identified by its;
grant dba to its;
conn its/its
create or replace directory exp as '/export/home/oracle/exp'; 



expdp its/its schemas=MOOC dumpfile=MOOC0929.dmp DIRECTORY=exp logfile=MOOC0929.log
expdp its/its schemas=HEUSER dumpfile=HEUSER929.dmp DIRECTORY=exp logfile=HEUSER0929.log
expdp its/its schemas=POST dumpfile=POST929.dmp DIRECTORY=exp logfile=POST0929.log
expdp its/its schemas=CMS dumpfile=CMS929.dmp DIRECTORY=exp logfile=CMS0929.log
expdp its/its schemas=QLIB dumpfile=QLIB929.dmp DIRECTORY=exp logfile=QLIB0929.log
expdp its/its schemas=RESCLOUD dumpfile=RESCLOUD929.dmp DIRECTORY=exp logfile=RESCLOUD0929.log
expdp its/its schemas=PLANTATION dumpfile=PLANTATION929.dmp DIRECTORY=exp logfile=PLANTATION0929.log
expdp its/its schemas=SAKAI dumpfile=SAKAI929.dmp DIRECTORY=exp logfile=SAKAI0929.log

导入命令
#导入之前指定环境变量ORACLE_SID
export ORACLE_SID=secondly1

#建立目录
export ORACLE_SID=secondly1
sqlplus / as sysdba
create user its identified by its;
grant dba to its;
conn its/its
create or replace directory exp as '/home/exp'; 

#确认环境变量正确即可执行导入导出命令
#echo $ORACLE_SID 
impdp its/its schemas=MOOC dumpfile=MOOC0929.dmp DIRECTORY=exp logfile=MOOCimp0929.log
impdp its/its schemas=HEUSER dumpfile=HEUSER929.dmp DIRECTORY=exp logfile=HEUSERimp0929.log
impdp its/its schemas=POST dumpfile=POST929.dmp DIRECTORY=exp logfile=POSTimp0929.log
impdp its/its schemas=CMS dumpfile=CMS929.dmp DIRECTORY=exp logfile=CMSimp0929.log
impdp its/its schemas=QLIB dumpfile=QLIB929.dmp DIRECTORY=exp logfile=QLIBimp0929.log
impdp its/its schemas=RESCLOUD dumpfile=RESCLOUD929.dmp DIRECTORY=exp logfile=RESCLOUDimp0929.log
impdp its/its schemas=PLANTATION dumpfile=PLANTATION929.dmp DIRECTORY=exp logfile=PLANTATIONimp0929.log
impdp its/its schemas=SAKAI dumpfile=SAKAI929.dmp DIRECTORY=exp logfile=SAKAIimp0929.log