Re: extents

At 01:13 AM 5/6/96 -0500, Thuc Nguyen wrote: >I am newly hired DBA. > >WARNING:TBLSpace coris:informix.syscolumns has more than 8 extents >I was told by an Informix Consultant to do the followings: >1. unload the table to a flat file >2. drop the table >3. create the table, get the extent size, next extent size, and row >leveling locking. >4. load the tape...this willneed to have constraints dropped > and trigger dropped. > >I cant find enough information about that script in any informix manual. Look at dbschema in the appendixes. If you have a relatively new version of Informix, you might be able to use the -ss option to create the correct schema. >Is an Informix Consultant right? Always! :) HTH. Hasta la vista! -- billy.wheeler@pixie.co.za