Re: alter table

Sahrul, Your problem has nothing to do with the number of locks, it is a log problem. The simplest way to do this change is to increase the number of logical logs. If you don't have enough disk space to do this you could try the following: - schedule a time when no users will be using the system - do a level 0 backup - do a dbschema to get a copy of the table schema - do a unload to get a copy of the data in the table - in onmonitor alter the archive tape device to /dev/null - ontape -s -N "your database" (check the logging mode before doing this) - alter the table - ontape -s -B or -U or -A (back to the old mode) "your database" - in onmonitor alter the archive tape device back to the old device - do a level 0 backup If anything goes wrong you can either restore the table using a load statement or do a full database restore. Regards David Ashby ______________________________ Reply Separator _________________________________ Hi, I need an advise, i try to alter a table,to put one field, but appear msg LONG TRANSACTION, and the alter aborted, this table has 252855 rows. This instance configuration has LOCKS = 30000. appreciated for any reply. sahrul