Table-name listing in ALL_TABLES but not in TABS
RajivJun 4 2010 — edited Jun 4 2010Hi
I was trying to programatically check whether a table is exist or not, and insert the records if exist (through Java). I am seeing a weired behavior wherein when I check the meta-data through my connection, I see that table_name present in it (don't think there's any error in this logic), but when I try to insert a record after that, it throws - java.sql.SQLException: ORA-00942: table or view does not exist.
When I manually check the DB, I can see that table in ALL_TABLES table but not in TABS (not sure what is the difference though between these two, and which is the correct place to check), desc <table_name> is also failing ...
I am really confused whether the table is exist or not ...
Any help is really appreciated.
Thanks,
Rajiv