oracle导出导入

expdp system/xxx@jwwl dumpfile=now.dmp schemas=jwwl

 

CREATE DIRECTORY idir as ‘d:/’;

SELECT * FROM dba_directories;

impdp system/xxx@jwwlkm DIRECTORY=idir dumpfile=now.dmp  schemas=jwwl  

impdp system/xxx@jwwlkm dumpfile=now.dmp REMAP_SCHEMA=jwwl:kmtest  TRANSFORM=segment_attributes:n

 

sqlplus /nolog
conn system/system
create tablespace jwwl  logging  datafile 'C:\app\Administrator\oradata\jwell\jwwl01.dbf'  size 20G   autoextend on   next 1G maxsize 30G  extent management local;
create user jwwl identified by jwwl default tablespace jwwl ;
grant connect,resource,dba to jwwl;
imp jwwl/jwwl file=d:/jwwl_2019_01_28.dmp;