3668: A table listed in the Dictionary is not present

Database
Enthusiast

3668: A table listed in the Dictionary is not present

Hello,

 

OVERRIDE ALL - command was run to release lock on table and it has corrupted the table and unable to delete the table with error 3668: A table listed in the Dictionary is not present

It in turn affecting dependale jobs such as Archiving.Error ARC1013:Table Header is missing in an AMP 

Any suggestions how to delete the table or rebuild it would be much appriciated. thank you.


Accepted Solutions
Teradata Employee

Re: 3668: A table listed in the Dictionary is not present

Sounds like you interrupted a restore/copy after the dictionary entries were updated but before any data was restored.

Possible ways to recover:

  • Do a restore/copy DATA TABLES for this table, and let it finish restoring the data
  • Do a restore/copy DICTIONARY TABLES for this table and let it finish, then BUILD the table (results in an empty table)
  • Drop the table and re-create it
  • Open an incident with Teradata Support for assistance in dropping the table
1 ACCEPTED SOLUTION
1 REPLY
Teradata Employee

Re: 3668: A table listed in the Dictionary is not present

Sounds like you interrupted a restore/copy after the dictionary entries were updated but before any data was restored.

Possible ways to recover:

  • Do a restore/copy DATA TABLES for this table, and let it finish restoring the data
  • Do a restore/copy DICTIONARY TABLES for this table and let it finish, then BUILD the table (results in an empty table)
  • Drop the table and re-create it
  • Open an incident with Teradata Support for assistance in dropping the table