2013年3月22日

Show error issue on oracle

摘要: 1 SQL> @CTODB_EVENT_PKG_EL.sql2 3 Package created.4 5 No errors.6 7 Warning: Package Body created with compilation errors.8 9 No errors.It`s very strange. See the code above. I put a show error behind the package header and package body. The script shows that package body compiled with error. But 阅读全文

posted @ 2013-03-22 17:41 kramer 阅读(319) 评论(0) 推荐(0) 编辑

Who is locking the DB account?

摘要: Sometimes the database account is locket frequently. That is because someone was trying to login to the database with a wrong password. So, you may want to find out the person and tell him/her to use a correct password. Below are the way to accomplish it.Before we start, you need to know you can ena 阅读全文

posted @ 2013-03-22 16:40 kramer 阅读(283) 评论(0) 推荐(0) 编辑

导航