ORA-04063: view "DAILY.TMP_TBX_100_0_S4" 有错误
来源:互联网 发布:像instagram的软件 编辑:程序博客网 时间:2024/05/16 07:30
执行:
CREATE TABLE TMP_TBX_100_0_S3 AS SELECT t.* FROM (select t1.*,NULL AS sdate, NULL AS report_id from TMP_TBX_100_0_S4_1 t1union all
select t2.* from TMP_TBX_100_0_S4_2 t2) t
报错:
ORA-00955: name is already used by an existing object
现象:
drop table TMP_TBX_100_0_S4 提示不错在表名或视图。
select * from TMP_TBX_100_0_S4
报错:
ORA-04063: view "DAILY.TMP_TBX_100_0_S4" 有错误
04063. 00000 - "%s has errors"
*Cause: Attempt to execute a stored procedure or use a view that has
errors. For stored procedures, the problem could be syntax errors
or references to other, non-existent procedures. For views,
the problem could be a reference in the view's defining query to
a non-existent table.
Can also be a table which has references to non-existent or
inaccessible types.
*Action: Fix the errors and/or create referenced objects as necessary.
原因:
查了很多资料,百思不得其解,后来把
drop table TMP_TBX_100_0_S4 改成 drop view TMP_TBX_100_0_S4。成功了!
原来是,存在名为 TMP_TBX_100_0_S4 的视图,不存在名为TMP_TBX_100_0_S4 的表。
反之亦然
- ORA-04063: view "DAILY.TMP_TBX_100_0_S4" 有错误
- Oracle的ORA-04063错误
- create view过程中遇到的ora-01031、ORA-00998错误
- ORA-04063: view "GFMIS.UNIFYLOGIN" has errors
- Daily
- 【ORA错误】ORA-12528
- addView出现view已经有父布局的错误
- CREATE VIEW ORA-01031
- ora-00341 ora-00312错误
- ora-01034 / ORA-27101 错误.
- ORA-01034&ORA-27101错误
- ORA-01034&ORA-27101错误
- ora-01034 ora-27101 错误
- ORA-01151;ORA-01537错误
- ORA-29913、ORA-30653错误
- ORA-07445 ORA-24324 ORA-01041错误
- Daily-C-Study(10):C语言关键字有哪些
- ora-00600 [12700]的故障一般是由于table或index的数据块有错误
- 解决Sublime Text窗口标签栏不见问题
- Xcode重构功能
- Your build settings specify a provisioning profile with the UUID, no provisioning profile was
- Servlet详解
- tomcat运行多个web app
- ORA-04063: view "DAILY.TMP_TBX_100_0_S4" 有错误
- jquery加载HTML片段
- oracle in 加select查询语句提示无效的字符
- hdu 3038(种类并查集)
- 1.2016年 物电学院 电气工程及其自动化专业 辛雅松 15050341033
- 皇子大战乌鸦(1)
- 网络基础---TCP连接
- 从零开始_学_数据结构(六)——排序(冒泡、插入、希尔、简单选择、归并、快速)
- HTTP/2 对 Web 性能的影响(上)