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

This depends on how large the table is. You might want to shut down logging if you have a table with over 1 million rows. You can also create the table and load it by: begin work; lock table [table name] in exclusive mode; load from [text file] insert into [table ]commit work This can be done if you have less than 500,000 rows in the table. : :Jason Berryhill <jason_berryhill@hp.com> wrote in article :<33D8D53E.5946@hp.com>... :> Greetings to INFORMIX practitioners: :> :> Can anyone tell me if it is possible to do a reorg. on a table within IN :> FORMIX without shutting down the database? I.E. keeping it online and :> working. :> :> :> Thanks all, :> :> Jason Berryhill :>