oracle本机导出数据库

导出

exp user/password@orcl file="e:\temp.dmp" full = y;

sqlplus tiger/scott@localhost/orcl

 

使用impdp 导入

 

创建表空间
create tablespace yssfa67 datafile 'd:\app\admin\oradata\orcl\yssfa67.dbf' size 500m autoextend on next 10m maxsize unlimited;

创建用户
create user yssfa67 identified by 1 default tablespace yssfa67;

给用户授权
grant dba to yssfa67;

导入
impdp yssfa45/1@orcl directory=dump_dir dumpfile=yssfa45_20180921.dmp full=y;

使用imp导入

create user app_frame identified by app_frame;
grant connect, resource, dba to app_frame;
imp app_frame/app_frame@orcl file = /home/oracle/Documents/dmp/app_frame.dmp  log =/home/oracle/Documents/dmp/dbimport.log full = y
revoke resource, dba from app_frame;