DBA > Job Interview Questions > Oracle DBA Checklist

Oracle DBA Checklist - Weekly Procedures - obj_c

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Oracle DBA Checklist - Weekly Procedures - obj_coord.sql

-- obj_coord.sql
--
-- To find out any difference in objects between two instances


SELECT object_name, object_type
FROM user_objects
MINUS
SELECT object_name, object_type
FROM user_objects@&my_db_link

Other Job Interview Questions