Home Page for the TeradataForum

Archives of the TeradataForum

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

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

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.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020