Archives of the TeradataForum

Message Posted: Thu, 20 Nov 2003 @ 11:47:04 GMT

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

Ian,

I think that the arc "dictionary rows" option will achieve this. After the restore (on your target system) you will then possibly have to use the "rebuild tables" command so that the developers can reference the tables in their sql.

Building the definition from dbc.tables etc may not work (and at best will be 'tricky' !), not all of the definition components are held in dictionary tables (e.g. Datablocksize option). Obviously if you don't use those options then this won't affect you. You can't use the RequestText/Createtext columns as they don't contain the full definition either.

Cheers,

Dave

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