首页 > Linux操作系统 > Linux操作系统 > 查询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博客 ” ,链接:https://blog.itpub.net/23757700/viewspace-706452/ ,如需转载,请注明出处,否则将追究法律责任。