oracle 异构环境oracle数据库迁移exp imp

exp/imp 普通的逻辑备份

查询数据库的数据文件位置,

select FILE_NAME,tablespace_name from dba_data_files;

创建表空间

create tablespace  bank_tls   datafile '/u01/app/oracle/orcl/datafile/bank_tls.dbf'   size 5M autoextend on maxsize 1G;
创建用户建立表空间

create user bankuser identified by bankpwd default tablespace bank_tls;

grant connect,resource to bankuser;
 

创建测试数据

conn bankuser/bankpwd

insert into bankuser.salgrade select * from scott.salgrade;

insert into bankuser.dept select * from scott.dept;

insert into bankuser.emp select * from scott.emp;

查看表所在表空间

select table_name,tablespace_name from user_tables;
备份数据

exp bankuser/bankpwd@orcl  file=/tmp/bankuser.dmp log=/tmp/bankuserExp.log
 

恢复数据

imp bank_bak/bank_bakpwd@horcl  fromuser=bankuser touser=bank_bak file=/tmp/bankuser.dmp  log=/tmp/bankuser
Imp.log