导出:
expdp t_pu_etl/t_pu_etl@10.136.16.131:1521/orcl schemas=APP_RPT directory=DATA_PUMP_DIR dumpfile=APP_RPT_20181225.dmp logfile=APP_RPT_20181225.log version=10.2.0.5.0
expdp t_pu_etl/t_pu_etl@10.136.16.131:1521/orcl schemas=APP_DBD directory=DATA_PUMP_DIR dumpfile=APP_DBD_20181225.dmp logfile=APP_DBD_20181225.log version=10.2.0.5.0
建新用户、表空间、授权:
--RPT_DBD
create TABLESPACE TBS_RPT_DBD
--datafile '+DATA/edwprd/datafile/TBS_RPT_DBD_data.dbf'
DATAFILE '/u01/app/oracle/oradata/orcl/TBS_RPT_DBD_data.dbf'
size 200m
autoextend on
next 50m maxsize 4096m
extent management local;
DROP USER RPT_DBD CASCADE ;
create user RPT_DBD identified by RPT_DBD default tablespace TBS_RPT_DBD;
--用户授权
grant CONNECT,RESOURCE,DBA to RPT_DBD;
REVOKE UNLIMITED TABLESPACE FROM RPT_DBD;
ALTER USER RPT_DBD QUOTA 0 ON USERS ;
ALTER USER RPT_DBD QUOTA UNLIMITED ON TBS_RPT_DBD ;
grant read,write on directory DATA_PUMP_DIR to RPT_DBD ;
REVOKE DBA FROM rpt_dbd ;
导入:
impdp RPT_PL/RPT_PL directory=DATA_PUMP_DIR dumpfile=APP_RPT_20181225.dmp logfile=APP_RPT_20181225.log REMAP_SCHEMA=APP_RPT:RPT_PL REMAP_TABLESPACE=TBS_APP:TBS_RPT_PL version=10.2.0.5.0
impdp RPT_DBD/RPT_DBD directory=DATA_PUMP_DIR dumpfile=APP_DBD_20181225.dmp logfile=APP_DBD_20181225.log REMAP_SCHEMA=APP_DBD:RPT_DBD REMAP_TABLESPACE=TBS_APP:TBS_RPT_DBD version=10.2.0.5.0