查詢DB物件是否同步

SELECT object_name, object_type
  FROM dba_objects@trac1
 WHERE wner = 'TRACDB2' AND status = 'VALID'
MINUS
SELECT object_name, object_type
  FROM dba_objects
 WHERE wner = 'TRACDB2' AND status = 'VALID' order by object_type

0,30,50 * * * * sh /Data/script/job/job_tascarerefre.sh >> /Data/script/log/job_tascarerefre.log 2>&1;
10,30,50 * * * * sh /Data/script/job/job_14654646.sh >> /Data/script/log/job_14654646.log 2>&1;

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23757700/viewspace-706452/，如需轉載，請註明出處，否則將追究法律責任。