Re: Can you reorg a Table without stopping the DB?

I've found ALTER FRAGMENT ... INIT ... to be even more useful for reorg on the fly. You don't have to code or care about a bunch of column names that don't have much to do with what you're trying to accomplish anyway. Check it out.... Greg Clem Akins wrote: > snip..... > See TFM on ALTER INDEX TO CLUSTER. The database stays online and working. > The table, however, is locked in exclusive mode, which may mean your app > is not able to do what it would otherwise do. > snip.....