Jane --

Have a look at the Database Index Recovery Tool (DIRT) in the files section.

HTH -- Bill

>I want to have a program that re-inexes all the tables. I set exclusive on and then close all tables. Then I open each one exclusive and issue a reindex command. I get the message that the file is already open & it isn't open exclusive. What should I be doing?
>
>
>Thanks.