2012年(101)
分类: Oracle
2012-06-12 15:50:29
SQL> rename ddl_actions to ddl_actions_bak;
rename ddl_actions to ddl_actions_bak
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of MONITOR.DDLTRIGGER
ORA-00600: internal error code, arguments: [16221], [96], [DDL_ACTIONS], [], [], [], [], [], [],
[], [], []
该对象记录DDL触发器抓取的记录信息,在触发器enable不能rename表对象,报以上错误信息.
解决办法:
关闭该对象的触发器,重新执行。
SQL>Alter trigger ddltrigger disable;
SQL> rename ddl_actions to ddl_actions_bak;
Table renamed.