oracle可以直接拷贝吗,ORACLE 复制环境到另外一个环境

DBA对于这种工作会经常处理，如果只是简单导入导出，没有特殊的权限及角色就不用过多的处理，如果复制的用户还有其他权限或角色，就需要在创建新用户时提前授权了，

否则在导入会报一些没有权限的错误，导致处理时间的浪费，下面是这次的处理流程，谨记。

expdp insightdb/insight    directory=DATA_PUMP_DIR  schemas=INSIGHTDB dumpfile=INSIGHTDB_20190129.dump compression=all parallel=4;

impdp insight_pro/insight_pro   directory=DATA_PUMP_DIR  dumpfile=INSIGHTDB_20190129.dump   parallel=4  remap_schema=INSIGHTDB:INSIGHT_PRO remap_tablespace=TBS_INSIGHT_DATA:TBS_INSIGHT_PRO

create tablespace tbs_insight_pro datafile '/oradata/tbs_insight_pro01.dbf' size 8G;

select * from dba_data_files;

/*drop user insight_pro cascade;

drop tablespace tbs_insight_pro including   contents and datafiles;*/

create user insight_pro identified by insight_pro default tablespace tbs_insight_pro;

grant resource,connect to insight_pro;

grant read,write on directory DATA_PUMP_DIR  to insight_pro;

grant CREATE VIEW              to insight_pro;

grant CREATE DATABASE LINK     to insight_pro;

grant UNLIMITED TABLESPACE     to insight_pro;

grant CREATE SYNONYM           to insight_pro;

grant SELECT ANY TABLE         to insight_pro;

grant DEBUG CONNECT SESSION    to insight_pro;

grant SELECT ANY DICTIONARY    to insight_pro;

grant CREATE MATERIALIZED VIEW to insight_pro;

grant dba to insight_pro ;