All Forums Database
TDUser2000 17 posts Joined 07/12
19 Dec 2012
Fastload Lock Release without table recreate option

Hello All,
 
I am on Teradata 13 version.I am looking for the options to release the fastload lock apart from dropping and creating the table . Can someone help me in releasing the fastload lock  and i am getting "2652: Operation not allowed: tablename is being Loaded." message when i query the table . I have written a dummy script to release the lock but didn't help.
Sample Script:
LOGON tddev/uid,pwd;
set record vartext ;
BEGIN LOADING DBTOOLS.TEST_1 ERRORFILES DBTOOLS.TEST_ERR1 , DBTOOLS.TEST_ERR2 ;

END LOADING;
LOGOFF;
Really appreciate the quick response.
 
Regards

You must sign in to leave a comment.