domingo, 1 de dezembro de 2013

Import EMS5 realizando o REMAP_SCHEMA - Oracle / AIX



Neste exemplo, abaixo estamos realizando o IMPORT de Owners do EMS5 utilizados para a conversão do EMS5 para o TOTVS 11 realizando REMAP_SCHEMA e REMAP_TABLESPACE.

No próximo post explicarei como os arquivos estão sendo localizados no directory / dump_file

impdp system/senha@instancia directory=exp_full dumpfile=exp_full_%U.dmp logfile=EMS505BPORO8P930UNI_REMAP.log schemas=EMS505BPORO8P930UNI  remap_schema=EMS505BPORO8P930UNI:EMS5CAD remap_tablespace=TS_EMS505BPORO8P930:ts_ems5,TSIND_EMS505BPORO8P930:tsind_ems5
impdp system/senha@instancia directory=exp_full dumpfile=exp_full_%U.dmp logfile=EMS505BPORO8P930BAS_REMAP.log schemas=EMS505BPORO8P930BAS  remap_schema=EMS505BPORO8P930BAS:EMS5CAD remap_tablespace=TS_EMS505BPORO8P930:ts_ems5,TSIND_EMS505BPORO8P930:tsind_ems5
impdp system/senha@instancia directory=exp_full dumpfile=exp_full_%U.dmp logfile=EMS505BPORO8P930VEN_REMAP.log schemas=EMS505BPORO8P930VEN  remap_schema=EMS505BPORO8P930VEN:EMS5CAD remap_tablespace=TS_EMS505BPORO8P930:ts_ems5,TSIND_EMS505BPORO8P930:tsind_ems5
impdp system/senha@instancia directory=exp_full dumpfile=exp_full_%U.dmp logfile=EMS505BPORO8P930EDI_REMAP.log schemas=EMS505BPORO8P930EDI  remap_schema=EMS505BPORO8P930EDI:EMS5CAD remap_tablespace=TS_EMS505BPORO8P930:ts_ems5,TSIND_EMS505BPORO8P930:tsind_ems5
impdp system/senha@instancia directory=exp_full dumpfile=exp_full_%U.dmp logfile=EMS505BPORO8P930FIN_REMAP.log schemas=EMS505BPORO8P930FIN  remap_schema=EMS505BPORO8P930FIN:EMS5MOV remap_tablespace=TS_EMS505BPORO8P930:ts_ems5,TSIND_EMS505BPORO8P930:tsind_ems5


Nenhum comentário:

Postar um comentário