Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > Oracle删除表时报错:表或视图不存在

Oracle删除表时报错:表或视图不存在

WBOY
Release： 2016-06-07 16:57:32
Original
1950 people have browsed it

明明该表是存在的,删除时报:表或视图不存在~! 第 1 行出现错误:ORA-00942: 表或视图不存在 后来终于找出原因是因为我的表名是小写

明明该表是存在的,删除时报:表或视图不存在~!

第 1 行出现错误:
ORA-00942: 表或视图不存在

后来终于找出原因是因为我的表名是小写的，，而是大写的则不会出现这个问题。

正常情况下....数据字典里面的数据都是大写,,,,动态视图都是小写的........在用关键字做表或其它对象的名时用""

所以表名用""引起来就行了

如何删除表时用了CASCADE CONSTRAINTS则会把与它相关的约束一起删除

linux

Related labels：
oracle data
source：php.cn
Previous article：Oracle表连接深入浅出 Next article：Ubuntu 下MySQL导入数据库.sql文件 命令
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to render data through DOM instead of through table I have a question about an application I'm creating, I'm using an Oracle database and I'm ...
From 2024-04-04 18:17:27
0
1
3567
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template