Re: How do add primary key contraint on existing table?

In article <3385DA3A.179B@ccm2.hf.intel.com>, Jorge Torralba <jorgex_tor ralba@ccm2.hf.intel.com> writes >> :but I get an ISAM error message that says it has run out of disk space. >> : > > >Keep in mind, if you alter a table Informix makes a copy of that table >before making changes to it. If your table is very big, you just might >not have enough room for the copy. > Correct - the copy gets created in the root dbspace by default. Look in your $INFORMIXDIR/etc/$ONCONFIG file and change DBSPACETEMP to be a comma separate list of dbpaces which should be used to store temporary tables which is what the ALTER TABLE effectively creates. E.g. DBSPACETEMP dbspace1,dbspace2,dbspace3 Then shutdown and startup online for the change to take effect. -- David Williams