Re: Copying over .dat and .idx files in SE 4

In <32CB0D56.CC36437@iui.com> Herschel Chandler <herschel@iui.com> writes: >What I would like to do is this: >Create the tables as I want them on a test/lab machine. >Take the 'live' server down (stop all sqlexecs and database accesses). >Remove table__123.dat and table__123.idx. Or move them to a safe area temporarily. >Copy in the new tables with the same filenames. >Reboot the machine. (Could possibly restart the server app, but reboot >is easier to do from remote). >Run bcheck against the new tables. >I've done some testing offline and it _appears_ to work. But I wanted >to get some other opinions on this. Is copying over tables an accepted >practice with Informix SE? Has anyone done something like this? Accepted practice? I think that's just anything that works isn't it :) . I've done this a few times on SE, and it always comes out fine provided that the table structures are identical and things like permissions are checked afterwards. Also remember to run UPDATE STATISTICS (if V4 has it) after the event. Bryan Tonnet batonnet@zeta.org.au