Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 24 Jun 2015 @ 21:56:46 GMT


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


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

Forum -

I am trying to copy the DDLs only using ARCMAIN (actually from ABUGUI). The script completes with warning, which I guess should be OK. However when I am trying to access the tables, it's throwing the error -

2654: Operation not allowed: Table is being restored.


I understand when you are doing a multi stream DATA restore, you will need to BUILD the table after the restoring each stream and you get this error, if you try to access the table before running the BUILD. But here, I am only trying to copy the DDLs. Here is my COPY script. Am I missing to do anything here? I also tried to release the locks thinking the database could be locked, but that was not the case.

     JOB DR_DDL_RES_JUL
     SESSIONS 30
     MULTISTREAM 1
     STREAM SMP001-8
     STREAMNAME WK_DDL_5581a0c40000002e_DSTREAM0001
     COMMANDLINE VBMASK=8199 NOTHREAD
     TDPID local
     USERID abubackupuser
     SOURCEUID 5581a0c40000002e
     DESTINATIONPATH /var/abu_storage/BACKUPS SCRIPT Restore LOGON $LOGON; COPY DICTIONARY TABLES
         (DATABASE1)(FROM(DATABASE1)),
     RELEASE LOCK,
     FILE=ARCHIVE;
     LOGOFF;
     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: 27 Dec 2016