oracle用户数据迁移

如果原来数据库中有相关数据，先删除用户：
> SQLPLUS / as sysdba
> DROP USER COSS6 CASCADE;
删除相应的表空间：（这里只是表空间删除方法，如果你需要的表空间是一样的，不必删除，删除用户及其文件就行了）
> SQLPLUS / as sysdba
> DROP TABLESPACE COSS6 INCLUDING CONTENTS AND DATAFILES;
> DROP TABLESPACE COSS6_TMP INCLUDING CONTENTS AND DATAFILES;

接下来准备coss迁移环境
1、创建表空间
CREATE TABLESPACE carrier DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\carrier.DBF'
SIZE 2G AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

2、创建临时表空间
CREATE TEMPORARY TABLESPACE coss6_TMP TEMPFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\coss6_TMP.DBF'
SIZE 500M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 4M;

3、创建用户并指定表空间和临时表空间
CREATE USER carrier IDENTIFIED BY coss6 DEFAULT TABLESPACE coss6 TEMPORARY TABLESPACE coss6_TMP ACCOUNT UNLOCK;

4、赋予用户权限
grant connect to carrier_dw;
grant resource to carrier_dw;
grant create view to carrier_dw;

4、导入coss数据库数据
imp coss6/coss6@orcl file='D:\Broadview\DB_gxCOSS.dmp' full=y;


grant connect to test;
grant resource to test;
grant create view to test;