Archives of the TeradataForum
Message Posted: Wed, 04 Feb 2009 @ 14:13:27 GMT
I am doing arcmain job to backup 3 tables with soft reference integrity.
I looking in DBC.All_RI_Children view and see row with InconsistenctFlag with N. That is good for me.
I delete those 3 tables and restore them in the same database.
I look again in DBC.All_RI_Children view no row found for those table. In my understanding, I expected find row with InconsistenctFlag with Y.
I look at the archmain command 'revalidate references for ...', but unfortunately, I did not get the reseult expected.
The soft reference integrity are gone.
Any information in my test appproach with soft RI backup-restore will be appreciate.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|