SQL>
metlink引用文檔
 |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |
Dropping a user schema results in below errors:
SQL> drop user GG_ADMIN; DROP USER "GG_ADMIN" Error at line 2 ORA-00604: error occurred at recursive SQL level 1 ORA-06576: not a valid function or procedure name ORA-06512: at line 21 gg_admin cascade;
A DDL trigger is defined on the drop statement.
Next query will get you the definition of the DDL Triggers in the system.
SQL> connect / as sysdba SQL> SELECT a.obj#, a.sys_evts, b.name FROM trigger$ a,obj$ b WHERE a.sys_evts > 0 AND a.obj#=b.obj# AND baseobject = 0; OBJ# SYS_EVTS NAME ---------- ---------- ------------------------------ 81794 8 LOGON_DATE 81795 8416 NO_VM_DDL 81796 128 NO_VM_DROP_A 13177 8192 AW_REN_TRG 13179 128 AW_DROP_TRG 11990 524256 LOGMNRGGC_TRIGGER 13175 4096 AW_TRUNC_TRG 71787 1 MGMT_STARTUP
Get an errorstack for ORA-06576 error:
SQL> alter system set events='6576 trace name errorstack level 3';
SQL> drop user <username>
When executing 'drop user gg_admin', the resultant trace file shows the failing statement is a call to wmsys.no_vm_drop_proc('USER', 'GG_ADMIN', '').
From errorstack trace file we could observe the following:
if (s_event='CREATE') then
execute immediate 'call wmsys.no_vm_create_proc(''' || sys.dictionary_obj_type || ''', ''' ||
sys.dictionary_obj_name || ''', ''' || sys.dictionary_obj_owner || ''')' ;
elsif (s_event='DROP') then
execute immediate 'call wmsys.no_vm_drop_proc(''' || sys.dictionary_obj_type || ''', ''' ||
sys.dictionary_obj_name || ''', ''' || sys.dictionary_obj_owner || ''')' ;
The triggers enabled for this were in this case NO_VM_DDL and NO_VM_DROP_A
Check if there are any DROP BEFORE triggers enabled. Once you drop the trigger, it will allow you to drop the user.
Workaround would be:
SQL> ALTER TRIGGER NO_VM_DDL DISABLE; SQL> ALTER TRIGGER NO_VM_DROP_A DISABLE; SQL> drop user gg_admin;
程序員人生，我編程，我富裕，記住wfuyu網，php教程，php學習，php手冊，CMS模版制作
聲明：本站大部分內容是作者原創，少部分收集于互聯網供大家一起學習，原版權很多不明，如有侵權請聯系本站，謝謝！
粵ICP備14040726號-1?? 2015-2020 程序員人生 版權所有
