48 lines
896 B
SQL
48 lines
896 B
SQL
-- eseguire come utente DBCGO
|
|
|
|
-----------------------------------------------------------------
|
|
|
|
create database link DWH
|
|
connect to DWH
|
|
identified by "<pwd>"
|
|
using 'MNP';
|
|
|
|
|
|
|
|
|
|
CREATE PUBLIC SYNONYM MNP_DWH_DON FOR MNP_DWH_DON@DWH;
|
|
|
|
|
|
|
|
CREATE PUBLIC SYNONYM MNP_DWH_REC_PUSH FOR MNP_DWH_REC_PUSH@DWH;
|
|
|
|
|
|
|
|
CREATE PUBLIC SYNONYM MNP_DWH_REC_DATI_VIEW FOR MNP_DWH_REC_DATI_VIEW@DWH;
|
|
|
|
|
|
|
|
CREATE PUBLIC SYNONYM MNP_DWH_REC_DATI_RIFIUTI_VIEW FOR MNP_DWH_REC_DATI_RIFIUTI_VIEW@DWH;
|
|
|
|
|
|
|
|
CREATE PUBLIC SYNONYM MNP_RECIPIENT_CANALE_VIEW FOR MNP_RECIPIENT_CANALE_VIEW@DWH;
|
|
|
|
|
|
|
|
CREATE PUBLIC SYNONYM MNP_DWH_POR FOR mnp_dwh_por@DWH;
|
|
|
|
|
|
|
|
CREATE PUBLIC SYNONYM MNP_DWH_CESS_IN FOR MNP_DWH_CESS_IN@DWH;
|
|
|
|
|
|
|
|
CREATE PUBLIC SYNONYM MNP_DWH_CESS_OUT FOR MNP_DWH_CESS_OUT@DWH;
|
|
|
|
|
|
|
|
CREATE PUBLIC SYNONYM MNP_MOB_INT_VIEW FOR MNP_MOB_INT_VIEW@DWH;
|
|
|
|
|
|
CREATE PUBLIC SYNONYM MNP_DELIBERA_DON_VIEW FOR MNP_DELIBERA_DON_VIEW@DWH; |