Delete Spotlight Object

select 'drop '||object_type||' '||object_name||';' from dba_objects where object_name like 'QUEST_%'

drop DIRECTORY QUEST_SOO_ADUMP_DIR;
drop DIRECTORY QUEST_SOO_BDUMP_DIR;
drop DIRECTORY QUEST_SOO_CDUMP_DIR;
drop DIRECTORY QUEST_SOO_UDUMP_DIR;
drop PACKAGE QUEST_SOO_ALERTTRACE;
drop PACKAGE BODY QUEST_SOO_ALERTTRACE;
drop TYPE QUEST_SOO_ALERTTRACE_LINE_TYP;
drop TYPE QUEST_SOO_ALERTTRACE_LOG_TYP;
drop TABLE QUEST_SOO_AT_APPNAME;
drop TABLE QUEST_SOO_AT_EXECUTION_PLAN;
drop VIEW QUEST_SOO_AT_EXECUTION_PLAN_V;
drop INDEX QUEST_SOO_AT_HASH_IDX;
drop TABLE QUEST_SOO_AT_OPERATIONS;
drop INDEX QUEST_SOO_AT_OP_PK;
drop TABLE QUEST_SOO_AT_PARSE_CURSOR;
drop TABLE QUEST_SOO_AT_PARSE_ERROR;
drop TABLE QUEST_SOO_AT_PARSE_WAITS;
。。。。。。。。
。。。。。。。。
。。。。。。。。



在删的时候可能会报 ORA-02449: 表中的唯一/主键被外键引用 的错误

多执行几遍即可