1.导出当前数据库序列为SQL语句,可直接复制到数据库中执行
select 'create sequence mesvue.'|| SEQUENCE_NAME || ' minvalue '||MIN_VALUE||' maxvalue '||MAX_VALUE||'
start with '||LAST_NUMBER||' increment by '||INCREMENT_BY||';' as sql
from dba_sequences where SEQUENCE_OWNER='MESVUE';
2.创建表空间,创建用户,给定权限
-- 创建表空间
create tablespace MESDEV
datafile 'E:\oradata\MESDEV.dbf'
size 1000m
autoextend on next 1000M maxsize 10240M;
-- userdev创建用户
create user userdev
identified by "123456"
default tablespace MESDEV
temporary tablespace MESDEV_temp
profile DEFAULT;
grant connect to mesdev;
grant dba to mesdev;
grant unlimited tablespace to mesdev;
3.exp/imp命令
注:运行CMD命令
导出表结构、过程存储及触发器等
exp username/password@orcl file=d:/pcs.dmp owner=pcs rows=n triggers=y
导入时如果出现创建时表存在错误情况,可使用ignore=y实现忽略错误继续导入操作。
imp username/password@orcl file=E:/dump/database.dmp full=y ignore=y