Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 25 Jun 2015 @ 14:15:39 GMT


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


Subj:   Re: Dictionary COPY throwing Error - Operation not allowed: Table is being restored
 
From:   Bakthavachalam, Roopalini

Thank you for all the response claryfying this :-).I ran a BUILD and was able to unlock the databases. I don't think we need to run COPY DATA TABLES.

Here is the BUILD script for the COPY script that I sent previously.

     JOB DATABASE_RES
     SESSIONS 30
     MULTISTREAM 1
     STREAM SMP001-8
     STREAMNAME WK_DATABASE_5581a0c40000002e_DSTREAM0001
     COMMANDLINE VBMASK=8199 NOTHREAD
     TDPID local
     USERID abubackupuser
     SOURCEUID 5581a0c40000002e
     DESTINATIONPATH /var/abu_storage/BACKUPS SCRIPT Restore LOGON $LOGON; BUILD DATA TABLES
     (DATABASE), RELEASE LOCK; ENDSCRIPT

Thanks

Roopalini



     
  <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: 15 Jun 2023