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 exists even after dropping

DevguyMar 23 2011 — edited Mar 23 2011
I dropped a table named contacts,but still it exists when i type "select * from tab"
SQL> drop table contacts;

Table dropped.

SQL> commit;

Commit complete.

SQL> drop table contacts;
drop table contacts
           *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> select * from tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
IMDB_TOP_250                   TABLE
BIN$F6bMvnw8TJKPvSnuh1APtg==$0 TABLE
BIN$zmR6g5IHTFmwn0V9Ura2Rw==$0 TABLE
BIN$zCxH4k4qSy65ccSfghjAqg==$0 TABLE
TEST                           TABLE
BIN$VPLTXcUvTymZfz/fp0X/WA==$0 TABLE
BIN$m+y9ZlWbQHeNlCorBWy2fQ==$0 TABLE
TEST1                          TABLE
contacts                       TABLE
Why i can still see contacts table in my schema?
This post has been answered by mbobak on Mar 23 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2011
Added on Mar 23 2011
11 comments
1,820 views