- 浏览: 643670 次
- 性别:
- 来自: 北京
文章分类
- 全部博客 (608)
- Java (125)
- Struts (16)
- Spring (19)
- iBatis (11)
- Hibernate (14)
- Oracle (33)
- Mysql (22)
- JBoss (4)
- JavaScript (46)
- Ajax (9)
- jQuery (5)
- web (25)
- Html (14)
- Exception (26)
- Linux (106)
- Vim (11)
- Python (12)
- ComputerTech (25)
- 文章 (50)
- Maven (20)
- FreeMarker (5)
- Json (0)
- Tomcat (6)
- ActiveMQ (2)
- Test (1)
- Git (5)
- Shell (1)
- 《Java并发编程实践》 (2)
- 产品设计 (1)
- xxx (0)
- diamond (1)
- dubbo (1)
- Raspbian (1)
- IDE (3)
- 并发编程 (1)
最新评论
-
mikzhang:
抱歉,写这篇文章时,博主开发的程序只面对IE浏览器,故没考虑其 ...
JS 中改变confirm默认按钮提示“确定""取消" -
poterliu:
测试过了,发现execScript方法只支持IE浏览器。目前已 ...
JS 中改变confirm默认按钮提示“确定""取消"
Cause: java.sql.SQLException: ORA-00942: table or view does not exist Then I try to run the sql statement that the webapp trying to execute before hitting this error and it returns the results without any error. The vendor give me the feedback that the table or the synonyms might be missing but I check and both of them exists. Since this is an UAT Database, so I just create a backup copy of that particular table and I start to rebuild the table from the grounds up. Then I finally discover the root cause of this incident. It is caused by the webapp user didn’t have access right to this object. We had did some maintenance job of that particular table recent days and it involve cloning and housekeeping and seems like the access privileges of that table get lost in these operation. After I grant back the access right and the dayend job runs without a hitch. Since there are so many possible reason causing this error, below are the steps that may help you identify your root cause: Replace OBJECT_NAME with the name of the table or view that you want to verify its existence. If this error occurred because the table or view does not exist, take the following actions:
from all_objects
where object_type in (’TABLE’,’VIEW’)
and object_name = ‘OBJECT_NAME‘;
发表评论
-
Oracle_ojdbc6 使用 报错
2015-06-10 14:29 944via: http://sd8089730.iteye.c ... -
It is indirectly referenced from required .class file
2014-08-19 15:30 404via: http://www.blogjava.net/z ... -
Hibernate_a different object with the same identifier value was already associat
2014-07-05 17:03 479via: http://www.blogjava.net/h ... -
Connection reset by peer: socket write error
2013-03-14 10:24 819Connection reset by peer: soc ... -
java.sql.SQLException: 索引中丢失 IN 或 OUT 参数
2012-05-07 17:00 2521java.sql.SQLException: 索引中丢失 ... -
org.apache.coyote.tomcat5.CoyoteResponseFacade.sendRedirec
2012-03-19 15:25 1586【from http://www.cxy.me/bbs/vie ... -
request.getHeader("referer") is null
2012-03-19 15:23 919referer 用来判断上一页是不是自己的网站 如果我 ... -
ORA-14551: cannot perform a DML operation inside a query
2012-04-26 14:49 1053ORA-14551: cannot perform a ... -
Struts FileUpload - Processing of multipart/form-data request failed
2011-09-16 15:52 7260Struts FileUpload 异常处 ... -
HTTP Status 500 - No action instance for path could be created
2011-09-16 15:03 1675HTTP Status 500 - No action ... -
java.sql.SQLException: ORA-01830: date format picture ends before converting ent
2011-08-17 17:48 3363java.sql.SQLException: ORA-0 ... -
Bean property 'xxDao' is not writable or has an invalid setter method
2011-08-08 16:25 8694Bean property 'xxDao' is not ... -
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null];
2011-08-04 15:38 2182网上解决方案 1.起初没有创建序列s_log,因此需要在Or ... -
org.xml.sax.SAXParseException: Document root element "struts-config", must match
2011-08-01 22:19 1642org.xml.sax.SAXParseException: ... -
Error creating form bean of class...
2011-08-01 10:44 975Error creating form bean of cla ... -
java.text.ParseException: Unparseable date: "11/10/10" at java.text.DateFormat.
2011-08-01 10:39 5558使用DateFormat的使用,然后自己试了下,结果出来个错误 ... -
[interceptor.FileUploadInterceptor:intercept] [Removing file filesXXX .tmp]
2011-07-25 11:18 4460上传完文件时控制台显示[interceptor.FileUpl ... -
The Network Adapter could not establish the connection
2011-07-15 17:05 12231、oracle配置 oracle9i2中把C:\ora ... -
java.sql.SQLException: ORA-00933: SQL 命令未正确结束
2011-06-30 12:16 2083java.sql.SQLException: ORA-0093 ... -
getOutputStream() has already been called for this response
2011-06-22 23:48 1586java.lang.IllegalStateExceptio ...
相关推荐
ORACLE9i exp遇见EXP-00008 ORA-00942 EXP-00024错误的解决方法,详细描述了问题处理的过程和步骤,共享在此,希望能有所帮助
Oracle 11gr2连Oracle 19c 报ORA-28040 ORA-01017解决方法
ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-...
oracle数据库ora-01152和ora-01110的解决办法
在启动Oracle数据库时提示:ORA-00845 MEMORY_TARGET not supported on this system错误,解决办法
oracle启动失败,ORA-00702报错,windows,linux系统下解决办法
之前用PL/SQL DEVELOPER和SQLPLUS 登录数据库都没有问题,就是应用程序通过JDBC连接Oracle时无法成功连接,出现ORA-12505错误listener does not currently know of SID given in connect descriptor
数据库导致连接出现异常的解决办法整理,这是 oracle连接问题的具体解决方案
oracle网络配置(listener_ora-sqlnet_ora-tnsnames_ora).mht
使用工具IMPDP导入数据时ORA-39002、ORA-39070错误排查。使用工具IMPDP导入数据时ORA-39002、ORA-39070错误排查 使用工具IMPDP导入数据时ORA-39002、ORA-39070错误排查
ORACLE ORA-00132 ORA-00214
Oracle Database on Linux Fails to Start - ORA-27154 ORA-27300 ORA-27301 ORA-27302: failure occurred at: sskgpbitsper (Doc ID 2789636.1)
ora-00604 错误 解决 方法 ora-00604 错误 解决 方法 ora-00604 错误 解决 方法 ora-00604 错误 解决 方法 ora-00604 错误 解决 方法ora-00604 错误 解决 方法
错误描述:oracle远程连接服务器出现 ORA-12170 TNS:连接超时 错误检查:有很多是oracle自身安装的问题,但是我这里服务器配置正常,监听正常,服务正常,远程可以ping通服务器。 这里主要是防火墙问题,解决办法: ...
客户端进行连接的时候,系统不定期出现ora-12520,ora-12516的连接问题, 问题解决方案建议: 1、增加process和session的连接数。 2、检查连接的应用,是不是有没有释放的连接。 3、将修改参数local_listener中的vip为...
Drop goldengate用户时,报ORA-00604 ORA-20782 ORA-06512错误
Oracle_ORA-12518故障_处理,希望在此与大家分享,能够在实际的工作中提高解决问题的能力
kettle连接oracle12C--报错ORA-28040 没有匹配的验证协议
解决ORA-01033 ORACLE 正在初始化或关闭
在运行查询SELECT * FROM V$SESSION 会出现ORA-29275:部分多字节字符的错误,这是什么原因开始我不得其解,网上也没有介绍什么好办法。本文给出答案。