Archives of the TeradataForum
Message Posted: Thu, 25 Jun 2015 @ 14:15:39 GMT
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
|