Archives of the TeradataForum

Message Posted: Sat, 25 Jul 2009 @ 15:33:41 GMT

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

<-- Anonymously Posted: Saturday, July 25, 2009 10:31 -->

Maybe, but WHY??? Not clear why you would create a temp table only to export it. Why not just export the data directly in the first place? You can have complicated SELECT statement in the export.

Also not clear why using "permanent" tables as staging tables is not allowed.

To even possibly use GTT, you'd have to populate the materialized instance (i.e. run the INSERT SELECT) from within the export session. Not at all sure you can get Infa to do it that way.

It's also not quite true that simultaneous insert to single table is impossible. The "bulk" loading utilities do use a table lock, as does INSERT SELECT. But TPump (TPT Stream operator) and BTEQ (TPT SQL Inserter) can use RowHash locks under certain conditions.

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