Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!i3g2000cwc.googlegroups.com!not-for-mail
From: erich.keane@verizon.net
Newsgroups: comp.databases.oracle.server
Subject: Re: to avoid errors while dropping not existing objects
Date: 10 Oct 2006 07:49:13 -0700
Organization: http://groups.google.com
Lines: 12
Message-ID: <1160491753.642401.144310@i3g2000cwc.googlegroups.com>
References: <egfkoe$f9l$1@nemesis.news.tpi.pl>
   <1160468489.664809.32270@i42g2000cwa.googlegroups.com>
   <egga22$mmn$1@nemesis.news.tpi.pl>
NNTP-Posting-Host: 69.26.100.251
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1160491758 12729 127.0.0.1 (10 Oct 2006 14:49:18 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 10 Oct 2006 14:49:18 +0000 (UTC)
In-Reply-To: <egga22$mmn$1@nemesis.news.tpi.pl>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: i3g2000cwc.googlegroups.com; posting-host=69.26.100.251;
   posting-account=P2CCAAwAAABGJedltBen0gb8sb7kaiY_
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276929

Your best bet in this case is to query the system tables.  Check out
the User_Tables table.

So, Select count(*) from User_Tables where Table_Name = '<Your
TableName>'

Note that Your TableName is case sensitive.  If the result is greater
than 0, it exists, else it does not

Documentation:
http://www.eveandersson.com/writing/data-model-reverse-engineering