RESTAURAR UN SCHEMA con datapump

datapump: RESTAURAR UN SCHEMA.sql

1.-TOMAMOS UN BACKUP 
nohup expdp USERID=\'/ as sysdba\' schemas=AMOSUSER_MIGRATION5, AMOSSERVER_MIGRATION5 directory=DATA_PUMP_DIR dumpfile=BACKUP_TRAINING5_20072016.dmp logfile=BACKUP_TRAINING5_20072016.log EXCLUDE=statistics  &


export_MIGRATION5_18072016.dmp

2.-DROPEAMOS LOS USUARIOS:

drop user AMOSSERVER_MIGRATION2 cascade;
drop user AMOSUSER_MIGRATION2 cascade;

3.-RECREAMOS LOS USUARIOS:

CREATE USER "AMOSSERVER_MIGRATION2" IDENTIFIED BY amos2015
   DEFAULT TABLESPACE "MIGRATION2"
      TEMPORARY TABLESPACE "TEMP"
      PROFILE "PASSWORD_NOEXPIRE";


  GRANT UNLIMITED TABLESPACE TO "AMOSSERVER_MIGRATION2";
   GRANT "CONNECT" TO "AMOSSERVER_MIGRATION2";
   GRANT "ROLE_AMOSSERVER" TO "AMOSSERVER_MIGRATION2";


CREATE USER "AMOSUSER_MIGRATION2" IDENTIFIED BY amos2015
   DEFAULT TABLESPACE "MIGRATION2"
      TEMPORARY TABLESPACE "TEMP"
      PROFILE "PASSWORD_NOEXPIRE";


GRANT ALTER SESSION TO "AMOSUSER_MIGRATION2";
GRANT CREATE SESSION TO "AMOSUSER_MIGRATION2";
GRANT "CONNECT" TO "AMOSUSER_MIGRATION2";


nohup impdp USERID=\'/ as sysdba\' schemas=AMOSUSER_MIGRATION5, AMOSSERVER_MIGRATION5 directory=DATA_PUMP_DIR dumpfile=export_MIGRATION5_18072016.dmp logfile=impdp_MIGRATION2_22072016.log  remap_schema=AMOSUSER_MIGRATION5:AMOSUSER_MIGRATION2, AMOSSERVER_MIGRATION5:AMOSSERVER_MIGRATION2 REMAP_TABLESPACE=AMOSDAT:MIGRATION2, AMOSIDX:MIGRATION2 &