Archives of the TeradataForum

Message Posted: Tue, 02 Sep 2003 @ 17:15:32 GMT

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

A CREATE TABLE ... AS of the following form causes a failure under V2R5.0 if any of the primary index columns is compressed on the source table :

CREATE TABLE mydbase.my_table  AS

(SELECT      T1.col_01
                        ,T1.col_03

FROM   proddbase.source_table_01                 T1
      ,proddbase.source_table_02                 T2

WHERE       ... etc
)

WITH NO DATA

PRIMARY INDEX     (T1.col_01, T2.col_02) ;

Under V2R4.1.3 the above worked - despite the manual implying that it wouldn't - and simply ignored the compression.

Does anyone know of a workaround that will still allow the convenience of using CREATE TABLE AS?

Thanks,

Gary

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