Archives of the TeradataForum

Message Posted: Thu, 30 Oct 2003 @ 15:48:57 GMT

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

Hi All,

Lets say I have a table and I have procedures and views built on that table. In the process of backing up I backup all of them and while restoring I restore the views and the procs first and then the table.

Is it ok to do it this way? Will I encounter some problems because of this (e.g., will the views or procs become invalid).

Is the only solution in such a case restoring the table first and then all other objects dependent on it?

Any information will be appreciated.

Rgds

Rohit

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