(个人整理)
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
orcl数据库的导入 导出
2023-11-06 12:15:10