Checking for an index before dropping it

From: <sumanp_at_my-deja.com>
Date: Wed, 05 Apr 2000 16:59:45 GMT
Message-ID: <8cfrdl$7r7$1@nnrp1.deja.com>

I would like to check for an index before dropping it. If the index doesn't exist and I try to drop it, Oracle gives me an error message.
I would like to suppress that error message, by checking beforehand, if the index on the table exists.

How can I accomplish this, using
SQL *Plus or TOAD?

Thanks.

---

Suman Mehta

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 05 2000 - 11:59:45 CDT