Archives of the TeradataForum

Message Posted: Mon, 06 Aug 2007 @ 20:17:56 GMT

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

<-- Anonymously Posted: Monday, August 06, 2007 14:20 -->

If you COPY the dictionary entries to a different target database name, the text of views (or macros) is unchanged. The resolver doesn't care about the view's own name, so if your intent is really to continue to reference objects in the original databases it will work. But if you intend to reference objects in a copied/renamed database, you will have to use some external mechanism to make the change. For example, you could SHOW all the source views, mass edit the names, then run the modified DDL on the target system.

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