Checking for an index before dropping it.
From: <sumanp_at_my-deja.com>
Date: Wed, 05 Apr 2000 17:41:39 GMT
Message-ID: <8cftsh$ao6$1_at_nnrp1.deja.com>
[Quoted] 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.
Suman Mehta
Date: Wed, 05 Apr 2000 17:41:39 GMT
Message-ID: <8cftsh$ao6$1_at_nnrp1.deja.com>
[Quoted] 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 - 19:41:39 CEST