Restore Failed : table id doesn't match for DBS.

Database

Restore Failed : table id doesn't match for DBS.

Hi,

I need to restore specific table from archive.

i did First :  Rename table XXX.table1 to XXX.table2;

after that create a table with the name "xxx.table1" successfully.

Now, we need to restore the data from archive.

Error :  table id doesn't match for dbs.

Can any one tell me the best restore process. Please.

1 REPLY
Teradata Employee

Re: Restore Failed : table id doesn't match for DBS.

To use RESTORE, leave the original table alone; if you want a backup of the contents, make a new backup table.

If you create a new target table, you must (re)GRANT any the access rights held on the original, and use COPY command instead of RESTORE.