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

Sorry, got on this thread late, so if this has already been said, my apologies. I think what Jason may be asking, ultimately, is how to keep the access to the table up with minimum downtime, while changing the table. The best way I know of is to lock the original table in share mode so nobody can update the table. Revoke all but Select permission on the table, so you are assured that no changes take place. Create a new table, new_table, with whatever organization you want. Select data from old_table, insert into new_table. Create indexes and permissions on new_table and whatever else you need, such as triggers and such. Drop old_table, or rename old_table something else. Rename new_table to old_table_name. Using this method your users will still be able to at least access the table to Select, but no changes will be allowed, for the duration of your load. This assumes you have the space available for 2 copies of the table in question. HTH. > The engine HAS to be up to re-org a table. Its the application that > will > most likely have to be shut-down. > > Chuck Ludwigsen > > 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 > > -- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply. Cosmo Lee Multi-User Computer Systems Brooklyn, NY "JUST SAY 'NO' TO SPAM" * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *