orcl数据库的导入 导出
浏览数：22 /
时间：2015年06月12日
(个人整理)
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/[email protected]:1521/orcl FULL=N FILE=D:\temp\db.dmp
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/[email protected]:1521/orcl FULL=N FILE=D:\temp\db.dmp
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
