arcmain refrential integrity


arcmain refrential integrity


I am using Teradata Express 14.x VM on my PC. I am running arcmain to archive a database test1 everything in it, then do a copy to create all objects in database test2.

  1. My tables have reverential integrities. Now after COPY is done, do I need to run some command to revalidate inconsistent references?

I have read archive/recovery utility manual but it is not clearly documented, what exactly is to be done.

  1. Also if tables have triggers, do I have to create all triggers? Once again, I do not find clear documentation
  2. Instead of copy it I use restore, will behavior of referential integrity constraints and triggers any different?