<!-- [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
/
视图已创建。
分享到:
相关推荐
“Controller does not exist.”登陆后台突然是这个提示登陆不上后台了。 入口为:index.php?m=admin 这是控制器不存在错误 应该是改过了系统文件,或者是上传文件缺失。 可以这样做,把phpcms/ 目录下的所有文件和...
标题 "does not exist. 解决 /root/.Xauthority does not exist" 涉及到的是一个常见的 Linux 系统问题,通常在使用图形界面(如 X Window System)或通过 SSH 远程连接时遇到。这个问题指出,系统找不到 `/root/....
models.py — 定义数据表 from django.db import models # Create your models here. class User(models.Model): username = models.CharField(max_length=20, primary_key=True) password = models.CharField(max...
Code::Blocks – The file does not exist. 1. Code::Blocks Could not open the file '/home/strong/codeblocks_work/Fire-master/src/bubble/config.cpp'. The file does not exist. 2. Build log ...... g++: ...
NULL 博文链接:https://snowelf.iteye.com/blog/507976
mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
版本:icloudpd1.7.2(GitHub - icloud-photos-downloader/icloud_photos_downloader: A command-line tool to download photos from iCloud) 错误:KeyError: 'dsInfo' 方案:修改指定文件,增加参数解决不同apple...
在phpcms系统中,如果你在打开网站时看到了“Action does not exist”的错误提示,那么这通常意味着程序在尝试访问或处理某个文件或页面时遇到了问题。具体到这个案例,问题出现在无法读取index.html文件。 首先,...
安装sap gui 750后,打开smartforms或scriptforms提示:CSapEditorCtrl::GetObject: Object 13 does not exist的解决方法:安装此安装包后即可解决问题
一般情况都是因为文件的上级目录不存在浏览权限。...详细说明:Serv_U安装设置以及530 Not logged in, home directory does not exist解决方法安装程序尽量采用最新版本,避免采用默认安装目录,设置好serv-u
NULL 博文链接:https://yangq.iteye.com/blog/1399621
log4j-99.0-does-not-exist.jar 处理logback和log4j的包冲突
解决SAPGUI800使用SMARTFORMS创建/编辑文本时报错CSapEditorCtrl::GetObject: Object 15 does not exist的对应版本SAPscript Legacy Text Editor patch安装包
使用nginx代理私有oss对象存储bucket桶,下载/访问文件。
在 Windows 操作系统中,`FILE_DOES_NOT_EXIST` 是一个错误代码,通常表示尝试访问的文件不存在于指定的位置。该错误代码在内核模式下通过 `NTSTATUS` 类型来表示,具体的值定义为 `0x00000005`。当应用程序或驱动...
当Eclipse提示"The archive: /bin/bootstrap.jar which is referenced by the classpath, does not exist."时,意味着Tomcat在试图启动时找不到这个必要的档案,这通常与Eclipse中的服务器配置有关。 描述中提到的...
标题 "The skin does not exist: Unable to determine the release version" 提到的问题,通常是与软件部署或更新时出现的错误有关,尤其是与版本控制或者界面显示有关。这可能是指在使用某些开源工具或框架时,系统...
Class Does Not Exist(解决方案).md
Warning: /opt/module/sqoop/bin/…/…/hcatalog does not exist! HCatalog jobs will fail. Please set $HCAT_HOME to the root of your HCatalog installation. Warning: /opt/module/sqoop/bin/…/…/accumulo ...
[ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=32, page number=57890], I/O length: 16384 bytes。 看起来是I/O出现了错误,但MySQL进程并未...