Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table-name listing in ALL_TABLES but not in TABS

RajivJun 4 2010 — edited Jun 4 2010
Hi

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
This post has been answered by sb92075 on Jun 4 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2010
Added on Jun 4 2010
7 comments
3,138 views