Wednesday, 26 October 2016

ORA-00942: table or view does not exist

Some times you may trying to  drop table which is exist in database but unfortunately you would get weird error saying that "table/view doesn't exist" even though table exist in database.


Here,one thing you need to observe.i.e.Check whether table is stored with upper case or lower case or mixed by querying in User_tables.

SQL> SELECT * FROM USER_TABLES;


By default all objects(i.e. table,view,procedures etc ) will be stored with upper case unless you specify case sensitive.

If you had created table or any object with with case sensitive then you cant drop those tables or objects directly with normal command.


You need specify double quotes " " both sides of your object while drop table/object.


lets check one example:


No comments:

Post a Comment