复制schema

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;