Archives of the TeradataForum
Message Posted: Thu, 30 May 2002 @ 11:28:50 GMT
| Subj: || || Re: Locks on table |
| From: || || Glen Blood |
Mload leaves a special mload lock on the table. Depending on which phase you left the table in, you can try:
Release mload on databasename.tablename; Acquisition Phase
Release mload on databasename.tablename in apply; Application phase.
/* You may have to drop all NUSIs. Only valid in V2R3 and later */
Otherwise, grab the DDL for the table, drop it and recreate it. If you have previous data in the table, you can use an access lock to
pull the data out.