Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Samuel
You would need to increase the number of logical logs. The reason is
that DDL statements such as ALTER are always logged regardless of
whether your database is logged or not.
HTH
Sujit
______________________________ Reply Separator _________________________________
Subject: Alter table (with large no. of data)
Author: "Samuel Tan" <mctan@hkstar.com> at internet
Date: 8/23/98 11:00 PM
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.