A query report table or views does not exist.

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 /

已连接。

 

 

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   /

 

视图已创建。