arc error

Database
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.

1 REPLY
Enthusiast

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.

Cheers,

Raja