|
|
Archives of the TeradataForum
Message Posted: Mon, 10 Nov 2003 @ 18:06:00 GMT
Subj: | | Re: Removing secondary indexes from table |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Monday, November 10, 2003 12:54 -->
Rachana, you might want to check if any ARC utility lock is on the table. Another thing which might be blocking your DROP ddl would a
previous rollback operation. If that is the case Create a new table procede with your work when the old one gets released drop that and
rename the new table...If you are on V2r5 I guess there are ways to rollback a rolling-back statement.
Hope that helps.
| |