Re: recreate all indexes on <tablename>

howard wrote:
> Hi,
>
> I've been asked by Oracle support to drop and recreate all the indexes
> on a table to deal with a ORA-600 error.
>
> Now, how would the database know what to re-create if I had just
> dropped the index?
>
> Do I just run "recreate all indexes on <tablename>" after I have
> dropped them?
>
> Thanks,
>
> Howard

There is no such things as RECREATE ALL INDEXES. Get your DDL and recreate them one at a time.

No version number but my instinct is that you should hand this over to a more senior person in your organization to demand a more senior person at Oracle.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group