Copy Dictionary & error 2654

Database
Enthusiast

Copy Dictionary & error 2654

Hello,
i experiment an error (2654) when i try to access tables created with a COPY DICTIONARY on a 'B' system, after archiving the tables on a 'A' system.
It looks much like a last-year subject in Teradata forum: "Backup structures only" - Oct,the 4th.
the response says that "The object restored using dictionary backup will remain unusable" :
Why ? Documentation on Archive / Recovery operations doesn't point it. What is wrong with a Copy Dictionary used to create those tables without data ?
Thanks for comment,
Pierre

PS: well ... i have just found the answer with arcmain:
BUILD DATA TABLES (Databasename.tablename), ...., release lock;
So i can access the tables.
Next time i'll take a few minutes ..
1 REPLY
Enthusiast

Re: Copy Dictionary & error 2654

To the best of my understanding, copy dictionary only copies the data dictionary rows for the table. It does not create the Table headers in the AMPS. that's where BUILD DATA TABLES comes into picture.