Archives of the TeradataForum

Message Posted: Wed, 04 Feb 2009 @ 14:13:27 GMT

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

Hi,

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.

Thank you

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