我在oracle中删除了一些表
DROP TABLE hr.admin_emp CASCADE CONSTRAINTS;
但已删除表的主键约束仍在数据字典中(all_constraints).现在我的问题是如何更新数据字典,以便它不显示已删除表的主键?例如,我使用此查询来选择hr模式:
SELECT A.TABLE_NAME,A.COLUMN_NAME,A.CONSTRAINT_NAME FROM ALL_CONS_COLUMNS A, ALL_CONSTRAINTS B WHERE B.OWNER='HR' AND A.OWNER='HR'AND A.CONSTRAINT_NAME = B.CONSTRAINT_NAME AND B.constraint_type='P';
结果是:
REGIONS REGION_ID
COUNTRIES COUNTRY_ID
LOCATIONS LOCATION_ID
DEPARTMENTS DEPARTMENT_ID
JOBS JOB_ID
EMPLOYEES EMPLOYEE_ID
JOB_HISTORY EMPLOYEE_ID
JOB_HISTORY START_DATE
BIN$rRfAMUTnQROvBfuhBCT6RQ==$0 ID
BIN$87Rd5FE7Rj2eQbim0H2EzA==$0 PK_B
BIN$bQeeD0M/QMSpLzYjZqAGeA==$0 PK_A
BIN$RzMu6nZiQ2yuj+4xQf7eAQ==$0 PK_A
具有奇怪表名的行是我删除的那些.