Archives of the TeradataForum

Message Posted: Thu, 22 Jun 2000 @ 12:15:16 GMT

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

Luc suggested creating a new database, creating the problem tables in that, backing it up to tape, then copying the tables from the archive to the real database. I've just tried this, but it doesn't seem to work. I get the same error when trying to copy all three tables, with a different number (or the word "All") at the end:

06/22/2000 12:58:19 *** Failure 2640:Specified table does not exist in 48.

I have located the original error which I get when trying to drop the table (3668) in the Teradata Messages Reference, and it says what I already know, that the likely cause is an uncompleted RESTORE operation. It also says that, if you get this error, there is an entry for the table in DBC.TVM. I am, however, reluctant to tamper with system tables.

Any further ideas gratefully accepted.

Thanks,

--
Julie Sorrell

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