Re: Help: Problems with ALTER TABLE
From: varol cavdar <varol_at_bilisim-ltd.com.tr>
Date: 1 Jul 2003 03:35:39 -0700
Message-ID: <e014aa93.0307010235.6ef5eb7b_at_posting.google.com>
Date: 1 Jul 2003 03:35:39 -0700
Message-ID: <e014aa93.0307010235.6ef5eb7b_at_posting.google.com>
Hi max,
For the first problem, you can not rename a table's column name in
Oracle 8i. This is a new future and it is allowed in 9.2 .
For your second problem, to enable a constraint in that table there
should be no active locks on it that is there should be no active
transaction modifying that table. You may try to get an exlusive lock
on that table before enable this constraint.
lock table tab1 in exclusive mode nowait; alter table tab1 enable constraint cons1;
best regards... Received on Tue Jul 01 2003 - 12:35:39 CEST