A query report table or views does not exist.

<!-- [if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:DrawingGridVerticalSpacing>7.8 磅</w:DrawingGridVerticalSpacing> <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery> <w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:SpaceForUL/> <w:BalanceSingleByteDoubleByteWidth/> <w:DoNotLeaveBackslashAlone/> <w:ULTrailSpace/> <w:DoNotExpandShiftReturn/> <w:AdjustLineHeightInTable/> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:UseFELayout/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!-- [if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]-->

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 /

视图已创建。