Re: Alter table (with large no. of data)

In article <6rpb1q$7i29@pegasus.hkstar.com>, mctan@hkstar.com (Samuel Tan) wrote: > Hi, > > I have tried to alter table by adding one more column in it. However, > it > fails after some time by displaying the following message: > > Long Transaction Aborted... > > How can I solve this problem by not unloading and reloading the data? > I've > already drop all the indexes except one of this table. The one I > haven't > dropped is the system index generated by the unique key when creating > the > table, something like " 384_12". > > Thank you! > > Rgds, > Samuel Tan > > > Increase the number/size of the logs or turn logging for the duration of transaction Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 #