1.创建Oracle用户并指定表空间的SQL语句
//创建临时表空间
create temporary tablespace exp_temp
tempfile 'C:\exp_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
//创建数据表空间
create tablespace exp_data
logging
datafile 'C:\exp_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
oracle账号extent management local;
//创建用户并指定表空间
create user exp identified by exp
default tablespace exp_data
temporary tablespace exp_temp;
//给用户授予权限
grant connect,resource,dba to exp;
2.创建Oracle序列
CREATE SEQUENCE SEQ_EXP — 序列名
INCREMENT BY 1 — 自增 1
START WITH 1 — 初始 1
NOMAXVALUE — 不设置最大值
NOCYCLE — 不循环
CACHE 10; — 缓存区
3.Oracle导入/出dmp文件
imp exp/exp@127.0.01:1521/orcl file=D:\exp.dmp full=y
exp exp/exp@127.0.01:1521/orcl file=D:\exp.dmp (full=y/owner=exp/tables=exp)