oracle 11g导入导出

sqlplus sys/sys@maximo as sysdba

host expdp xtoa/aws2012@xtorcl dumpfile=20130411.dmp

sqlplus sys/sys as sysdba
drop user xtoa cascade;

create tablespace xtoa
datafile 'e:\app\Administrator\product\11.2.0\data\XT\xtoa.dbf' 
size 1000m  
autoextend on  
next 50m maxsize 20480m  
extent management local;

create temporary tablespace tempdata
tempfile 'e:\app\Administrator\product\11.2.0\data\XT\tempdata.dbf' 
size 100m  
autoextend on  
next 50m maxsize 200m  
extent management local; 

create user xtoa identified by aws2012 default tablespace xtoa temporary tablespace tempdata;

grant dba to xtoa;

host impdp xtoa/aws2012@xtorcl dumpfile=20130320.dmp;