I have a situation where I delete all records in a table and then I
drop the index on that table.
The sql is

delete from Table;
drop index Table_Index;

but because I have done delete before dropping the index the index
is in use and I cannot drop it. How do I get around it.

Thanx

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz