orcl数据库的导入 导出

(个人整理)
orcl数据库导入整理：


====临时表空间==== 
create temporary tablespace cqq
tempfile 'D:\caoqiuqin\orcl\cqq.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;


====表空间==== 
create tablespace zhongnan
logging
datafile 'D:\caoqiuqin\orcl\zhongnan.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;


====创建用户并指定表空间和临时表空间====
create user zhongnan identified by zhongnan123
default tablespace zhongnan
temporary tablespace cqq;


====授予权限====
grant create session,create table,create view to zhongnan;


grant DBA to zhongnan;




然后 cmd指令imp zhongnan/zhongnan123@orcl file=C:\Users\admin\Desktop\orcl\1.dmp full=y;（其中C:\Users\admin\Desktop\orcl\1.dmp是要导入的数据库的源文件）




exp zhongnan/zhongnan123@192.168.0.200:1521/orcl FULL=N FILE=D:\temp\db.dmp