导入数据库(oracle)

/*创建表空间*/
create tablespace seadms  

logging  

/*定义数据文件*/
datafile 'C:\Program Files\Oracle\seadms_01.dbf' 
size 50m  
autoextend on  
next 50m maxsize 32767M;


/*create tablespace seadmsindex  
logging  
datafile 'C:\Program Files\Oracle\seadmsindex_01.dbf' 
size 50m  
autoextend on  
next 50m maxsize 32767M;8*/




/*第3步：创建用户/定义密码  指定表空间  */
create user huanghaitest identified by seadms
default tablespace seadms;




/*第4步：给用户授予权限  */
grant connect,resource,dba to huanghaitest


create directory dir_seadms as 'D:/'; 


/*impdp aystem/123123 directory=dir_dp dumpfile=BMS_20150322.dmp 
/*impdp bms/bms@orcl(orcl为oracle的SID) directory=dir_dp dumpfile=BMS_20150322.dmp 
expdp rdslcib/rdslcib@ORCL1 DIRECTORY=test_dir dumpfile=rdslcib.dmp*/


impdp system/123123@orcl directory=dir_seadms  dumpfile=CORDISSTG_20160801.DMP
 /*remap_tablespace=dms:seadms,DMSIDX:seadmsindex;*/