Tibero Mig Script
-- 1. 테이블 비교 -- : day2서버를 기준으로 day2서버에 있는 테이블이 mig서버에는 존재안하는지 체크한다. -- ex) SELECT * FROM (SELECT A.TABLE_NAME AS BAK_DAY2_TABLE_NAME, B.TABLE_NAME AS N_MIGDB_TABLE_NAME FROM (SELECT TABLE_NAME FROM DBA_TABLES@TTOO WHERE OWNER IN( 'MVOC', 'SVOCRUN' ) -- AND ( SUBSTR(TABLE_NAME,1,3) IN ('AUD','CDC','COM','SDA','SFA' ,'STR') OR TABLE_NAME IN ('CAMP_RESULT_NEW','CONTRACT_NEW','ORA_DDL_LOG','QST_CASE..
2023. 12. 12.