arc error

Teradata Employee

arc error

hi all,when I resore table from backup tape.there are the following error msg.*** Failure 9011:Table being Archived/Restored/Copied was

dropped by some other transaction.How to handle it.Thanks.


Re: arc error

Hi Zhang,


Explanation: The table that is being Archived/Restored/Copied has been dropped by some other transaction. This can happen when the HUT Lock is released using RELEASE LOCK statement allowing for Drop Table.

Generated By: ModifyTblHdr.

For Whom: End Users.

Remedy: This is a user error. User must not release the HUT LOCK and drop table while Arc/Restore/Copy is in progress.