A query report table or views does not exist.

最新推荐文章于 2022-04-10 17:40:37 发布

最新推荐文章于 2022-04-10 17:40:37 发布 · 92 阅读

本文介绍了解决在Oracle数据库中创建视图时遇到的表不存在错误的具体步骤。通过检查表名、权限设置并最终成功创建视图的过程，为读者提供了实用的操作指南。

A query report table or views does not exist.

At last , find it is caused by the view.

The try to create the view with following steps.

Sqlplus /

SQL> CREATE OR REPLACE VIEW spyglass.CRV_SUPPORT_CENTER

2 (CUSTOMERID, CUSTOMERNAME, SUPPORTCENTERID, SUPPORTCENTER)

3 AS

4 SELECT sca.CUSTOMERID,

5 ci.CUSTOMERNAME,

6 sca.SUPPORTCENTERID,

7 lusc.SUPPORTCENTER

8 FROM spyglass.SC_ASSIGNMENT sca,

9 spyglass.LUSUPPORTCENTER lusc,

10 account.customerinfo ci

11 WHERE lusc.SUPPORTCENTERID = sca.SUPPORTCENTERID(+)

12 and sca.customerid = ci.customerid

13 /

account.customerinfo ci

第 10 行出现错误 :

ORA-00942: table or view does not exist

SQL>

SQL> desc account.customerinfo

名称是否为空 ? 类型

----------------------------------------- -------- ----------------------------

CUSTOMERID NOT NULL NUMBER

ENTERPRISEID NUMBER

EXECUTIVESPONSORID NUMBER

CUSTOMERSTATUSID NUMBER

CUSTOMERNAME VARCHAR2(100)

SALESTYPEID NUMBER

ALIASCUSTOMERID VARCHAR2(100)

TICKER VARCHAR2(6)

PARTNERID NUMBER

COMPANYURL VARCHAR2(255)

NOTES VARCHAR2(2000)

POPUPNOTE VARCHAR2(4000)

ISMUSERID VARCHAR2(20)

ISMURL VARCHAR2(128)

ISMDESCRIPTION VARCHAR2(512)

EMAILNOTIFICATION VARCHAR2(50)

EXTERNALID VARCHAR2(50)

CUSTOMERTYPEID NUMBER

CUSTOMERMODE VARCHAR2(2)

PORTALID NUMBER

PUBLISHWORKLOG NUMBER

NOCID NUMBER

NUC_ITO_NODE_GROUP VARCHAR2(30)

NUC_NAME VARCHAR2(30)

NUC_REMEDY_ORG_ALIAS VARCHAR2(30)

SUPPORTEMAILID NUMBER

EMAILSUMMARY NUMBER

CODEBLUE NUMBER

CUSTOMERDISTRIBUTIONCODEID NUMBER

CTASHIPPINGADDRESS VARCHAR2(2000)

ALERTFROMADDRESS VARCHAR2(255)

REGION VARCHAR2(255)

FINANCIAL_SYS_NUMBER VARCHAR2(255)

Guess it is caused by the permission.

Becasue the view is under the spyglass schema.

The Object permission need to be granted by owner.

It can not be done by even DBA.

SQL> conn account

已连接。

SQL> grant select on account.customerinfo to spyglass;

授权成功。

SQL> conn /