[大数据]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