Archives of the TeradataForum

Message Posted: Thu, 30 May 2002 @ 11:28:50 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

Glen

	<Prev	Next>		<<First	<Prev	Next>	Last>>