发布时间:2012-12-18 16:30:42
ORA-03001: Unimplemented Feature when Running DBMS_STATS.GATHER_INDEX_STATS [ID 559389.1] In this Document Symptoms Cause Solution ReferencesApplies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2Information in this do......【阅读全文】
发布时间:2012-12-18 16:12:02
ORA-03001: unimplemented feature错误处理今天,邮箱收到生产库alert错误日志,再次证明我的alert日志监控脚本还是很好用的。环境:oracle Database 11g Enterprise Edition Release 11.1.0.6.0 System name: LinuxRelease: 2.6.18-238.19.1.el5xen-----------------------alert log------------------......【阅读全文】
发布时间:2012-12-10 22:06:14
ORA-24247: network access denied by access control list (ACL) 错误处理及DBMS_NETWORK_ACL_ADMIN用法汇总通过oracle的存储过程发邮件,出现问题,具体过程如下:发邮件的存储过程PROC_SENDMAIL_SIMPLE在A用户,而B用户要调用A用的PROC_SENDMAIL_SIMPLE来发邮件。其中,A用户已经把PROC_SENDMAIL_SIMPLE的执行权限给了B用户grant execute on PROC_SENDMAIL_SIMPLE to B;但是在B用户的存储过程中调用PROC_SENDMAIL_......【阅读全文】