|
Oracle DBA Checklist - Weekly Procedures - No_pk.sql
Oracle DBA Checklist
(Continued from previous question...)
Oracle DBA Checklist - Weekly Procedures - No_pk.sql
-- no_pk.sql
--
-- To find tables without PK constraint
SELECT table_name
FROM all_tables
WHERE owner = '&OWNER'
MINUS
SELECT table_name
FROM all_constraints
WHERE owner = '&&OWNER'
AND constraint_type = 'P'
(Continued on next question...)
Other Interview Questions
| 