A query report table or views does not exist.

来源：互联网发布：java中settitle大小编辑：程序博客网时间：2024/06/05 18:22

A query report table or views does notexist.

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.LUSUPPORTCENTERlusc,

10 account.customerinfo ci

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

12 andsca.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 byowner.

It can not be done by even DBA.

SQL> conn account

已连接。

SQL> grant select onaccount.customerinfo to spyglass;

授权成功。

SQL> conn /