以下脚本可以用于列出数据库中没有主键的表,已排除了系统schema:
REM List tables with no primary keySELECT owner, table_nameFROM dba_tablesWHERE 1 = 1AND owner NOT IN('SYS','SYSTEM','SYSMAN','EXFSYS','WMSYS','OLAPSYS','OUTLN','DBSNMP','ORDSYS','ORDPLUGINS','MDSYS','CTXSYS','AURORA$ORB$UNAUTHENTICATED','XDB','FLOWS_030000','FLOWS_FILES')MINUSSELECT owner, table_nameFROM dba_constraintsWHERE constraint_type = 'P'AND owner NOT IN('SYS','SYSTEM','SYSMAN','EXFSYS','WMSYS','OLAPSYS','OUTLN','DBSNMP','ORDSYS','ORDPLUGINS','MDSYS','CTXSYS','AURORA$ORB$UNAUTHENTICATED','XDB','FLOWS_030000','FLOWS_FILES')/
以下脚本可以用于列出数据库中没有唯一约束或索引的表,已排除了系统schema:
REM List tables with no unique key or index SELECT owner, table_nameFROM dba_all_tablesWHERE 1 = 1AND owner NOT IN('SYS','SYSTEM','SYSMAN','EXFSYS','WMSYS','OLAPSYS','OUTLN','DBSNMP','ORDSYS','ORDPLUGINS','MDSYS','CTXSYS','AURORA$ORB$UNAUTHENTICATED','XDB','FLOWS_030000','FLOWS_FILES')MINUSSELECT owner, table_nameFROM dba_constraintsWHERE constraint_type = 'U'AND owner NOT IN('SYS','SYSTEM','SYSMAN','EXFSYS','WMSYS','OLAPSYS','OUTLN','DBSNMP','ORDSYS','ORDPLUGINS','MDSYS','CTXSYS','AURORA$ORB$UNAUTHENTICATED','XDB','FLOWS_030000','FLOWS_FILES')MINUSSELECT owner, table_nameFROM dba_indexesWHERE uniqueness = 'UNIQUE'AND owner NOT IN('SYS','SYSTEM','SYSMAN','EXFSYS','WMSYS','OLAPSYS','OUTLN','DBSNMP','ORDSYS','ORDPLUGINS','MDSYS','CTXSYS','AURORA$ORB$UNAUTHENTICATED','XDB','FLOWS_030000','FLOWS_FILES')/