131 lines
2.9 KiB
SQL
131 lines
2.9 KiB
SQL
PROMPT Create PUBLIC SYNONYM of DWH
|
|
|
|
DEFINE owner = DWH
|
|
|
|
-- AB2 module
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_a0mo
|
|
FOR &owner..a0mo_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_a0cy
|
|
FOR &owner..a0cy_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_a1ao
|
|
FOR &owner..a1ao_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_a1id
|
|
FOR &owner..a1id_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_a1in
|
|
FOR &owner..a1in_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_a1ow
|
|
FOR &owner..a1ow_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_a2at
|
|
FOR &owner..a2at_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_a2br
|
|
FOR &owner..a2br_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_a2de
|
|
FOR &owner..a2de_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_a2ku
|
|
FOR &owner..a2ku_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_a2ne
|
|
FOR &owner..a2ne_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_a2tr
|
|
FOR &owner..a2tr_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_a3fi
|
|
FOR &owner..a3fi_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_afrcu
|
|
FOR &owner..afrcu_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_ahasl
|
|
FOR &owner..ahasl_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_akerj
|
|
FOR &owner..akerj_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_d5d0
|
|
FOR &owner..d5do_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_d8dh
|
|
FOR &owner..d8dh_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_glbal
|
|
FOR &owner..glbal_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_glhst
|
|
FOR &owner..glhst_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_glplr
|
|
FOR &owner..glplr_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_h7ku
|
|
FOR &owner..h7ku_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_h8arr
|
|
FOR &owner..h8arr_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_h8bl
|
|
FOR &owner..h8bl_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_h8po
|
|
FOR &owner..h8po_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_m4cuc
|
|
FOR &owner..m4cuc_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_m4cug
|
|
FOR &owner..m4cug_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_m4cui
|
|
FOR &owner..m4cui_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_m4cu
|
|
FOR &owner..m4cu_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_m4cubi
|
|
FOR &owner..m4cubi_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_m4cufr
|
|
FOR &owner..m4cufr_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_m4curl
|
|
FOR &owner..m4curl_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_m4cult
|
|
FOR &owner..m4cult_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_m5re
|
|
FOR &owner..m5re_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_mrtt1rk
|
|
FOR &owner..mrtt1rk_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_tfgen
|
|
FOR &owner..tfgen_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_x9xcg
|
|
FOR &owner..x9xcg_staging;
|
|
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_chartaccount
|
|
FOR &owner..dim_chartaccount;
|
|
|
|
-- Treasury module
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_fx
|
|
FOR &owner..fx_staging;
|
|
|
|
CREATE OR REPLACE PUBLIC SYNONYM syn_mm
|
|
FOR &owner..mm_staging;
|
|
|
|
|