recreate all indexes on

Giganews Newsgroups
Subject: recreate all indexes on <tablename>
Posted by:  howard (pkowal…@gmail.com)
Date: 12 Sep 2006

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

Replies