oracle数据库数据迁移

两种方式：按用户，按表结构。

方式一：按用户

导入当前数据库信息

1、导出数据---生产环境

exp imaging/imaging@10.124.84.25/img owner=imaging file=d:/imaging.dmp

exp sunimage/sunimage@10.124.84.25/img owner=sunimage file=d:/sunimage.dmp

exp sunflow/sunflow@10.124.84.25/img owner=sunflow file=d:/sunflow.dmp

2、删除用户---UAT环境

drop user imaging CASCADE;

drop user sunimage CASCADE;

drop user sunflow CASCADE;

3、创建用户---UAT环境

create user imaging identified by edmuat;

grant dba to imaging with admin option;

create user sunimage identified by edmuat;

grant dba to sunimage with admin option;

create user sunflow identified by sunflow;

grant dba to sunflow with admin option;

4、导入数据---UAT环境

imp imaging/imaging@10.124.84.91/img fromuser=imaging file=d:/imaging.dmp

imp sunimage/sunimage@10.124.84.91/img fromuser=sunimage file=d:/sunimage.dmp

imp sunflow/sunflow@10.124.84.91/img fromuser=sunflow file=d:/sunflow.dmp

补充：创建表空间

CREATE  TABLESPACE imaging LOGGING DATAFILE  'C:\oracle\product\10.2.0\oradata\orcl\imaging_DATA01.DBF'  

   SIZE 500M AUTOEXTEND  ON  NEXT  32M MAXSIZE 5000M EXTENT MANAGEMENT LOCAL;

CREATE   USER  sunflow IDENTIFIED  BY  sunflow DEFAULT  TABLESPACE imaging;