复制schema

来源：互联网发布：数据库基础视频编辑：程序博客网时间：2024/06/06 10:02

expdp system/oracle@orcl DIRECTORY=db_backup DUMPFILE=FALABELLA_AR_20121024.DMP SCHEMAS=FALABELLA_AR_TAX,FALABELLA_AR_CORE,FALABELLA_AR_PUB,FALABELLA_AR_CATA,FALABELLA_AR_CATB logfile=falabella_expdp_AR_201021024.log CONTENT=ALL COMPRESSION=ALL FLASHBACK_TIME=SYSDATE

drop user FALABELLA_AR2_CATB cascade;
drop user FALABELLA_AR2_CATA cascade;
drop user FALABELLA_AR2_PUB cascade;
drop user FALABELLA_AR2_CORE cascade;
drop user FALABELLA_AR2_TAX cascade;

CREATE USER FALABELLA_AR2_CATA IDENTIFIED BY FALABELLA_AR2_CATA QUOTA UNLIMITED ON TBS_FALABELLA
DEFAULT TABLESPACE TBS_FALABELLA
TEMPORARY TABLESPACE TBS_FALABELLA_TEMP
/
GRANT CONNECT, RESOURCE,DBA TO FALABELLA_AR2_CATA;

CREATE USER FALABELLA_AR2_CATB IDENTIFIED BY FALABELLA_AR2_CATB QUOTA UNLIMITED ON TBS_FALABELLA
DEFAULT TABLESPACE TBS_FALABELLA
TEMPORARY TABLESPACE TBS_FALABELLA_TEMP
/
GRANT CONNECT, RESOURCE,DBA TO FALABELLA_AR2_CATB;

CREATE USER FALABELLA_AR2_CORE IDENTIFIED BY FALABELLA_AR2_CORE QUOTA UNLIMITED ON TBS_FALABELLA
DEFAULT TABLESPACE TBS_FALABELLA
TEMPORARY TABLESPACE TBS_FALABELLA_TEMP
/
GRANT CONNECT, RESOURCE TO FALABELLA_AR2_CORE;

CREATE USER FALABELLA_AR2_PUB IDENTIFIED BY FALABELLA_AR2_PUB QUOTA UNLIMITED ON TBS_FALABELLA
DEFAULT TABLESPACE TBS_FALABELLA
TEMPORARY TABLESPACE TBS_FALABELLA_TEMP
/
GRANT CONNECT, RESOURCE,DBA TO FALABELLA_AR2_PUB;

alter user FALABELLA_AR2_CATA account lock;
alter user FALABELLA_AR2_CATB account lock;
alter user FALABELLA_AR2_CORE account lock;
alter user FALABELLA_AR2_PUB account lock;
alter user FALABELLA_AR2_TAX account lock;

impdp system/oracle@orcl DIRECTORY=db_backup DUMPFILE=FALABELLA_AR_20121024.DMP LOGFILE=impdp_FALABELLA_AR2_20121024.log SCHEMAS=FALABELLA_AR_TAX,FALABELLA_AR_CORE,FALABELLA_AR_PUB,FALABELLA_AR_CATA,FALABELLA_AR_CATB REMAP_SCHEMA=FALABELLA_AR_TAX:FALABELLA_AR2_TAX,FALABELLA_AR_CORE:FALABELLA_AR2_CORE,FALABELLA_AR_PUB,FALABELLA_AR2_PUB,FALABELLA_AR_CATA,FALABELLA_AR2_CATA,FALABELLA_AR_CATB,FALABELLA_AR2_CATB CONTENT=ALL PARALLEL=1 TABLE_EXISTS_ACTION=REPLACE;

alter user FALABELLA_AR2_CATA account unlock;
alter user FALABELLA_AR2_CATB account unlock;
alter user FALABELLA_AR2_CORE account unlock;
alter user FALABELLA_AR2_PUB account unlock;
alter user FALABELLA_AR2_TAX account unlock;