Oracle DB表或视图不存在 [英] Oracle DB table or view does not exist

问题描述

我正在尝试将Oracle数据库连接到我的JAVA Web项目。
并且在使用系统用户连接创建与数据库的连接时成功建立。

I'm trying to connect a Oracle database to my JAVA web project. and when creating the connection to the database using system user connection is successfully established.

但是当我在连接中执行一个简单的select *命令时，它说

But when I execute a simple select * command in the connection it says

错误代码942，SQL状态42000：ORA-00942：表或视图不存在。

Error code 942, SQL state 42000: ORA-00942: table or view does not exist.

这些sql查询在sqldeveloper中工作。没有错误。

These sql queries work in sqldeveloper. No errors.

我正在使用oracle 10g瘦客户机ojdbc6驱动程序和jdk 1.7

I'm using oracle 10g thin client ojdbc6 driver and jdk 1.7

什么可以是问题？

Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Error Code: 942
Call: SELECT USERID, FULLNAME, USERNAME, USER_CREDENTIALSID, USER_TYPEID FROM USERS
Query: ReadAllQuery(referenceClass=Users sql="SELECT USERID, FULLNAME, USERNAME, USER_CREDENTIALSID, USER_TYPEID FROM USERS")

推荐答案

问题是以系统用户身份连接。我在oracle管理页面中看到了一个名为JPAMAGAZINE的帐户。使用该帐户连接并且有效。

Problem was connecting as the system user. I saw an account in oracle administration page called JPAMAGAZINE. connected using that account and it worked.

这篇关于Oracle DB表或视图不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！