Archives of the TeradataForum
Message Posted: Tue, 12 Dec 2012 @ 01:36:00 GMT
Subj: | | Re: How to copy table containing identity column? |
|
From: | | Geeta Kudumula |
I am not sure whether you are using Unity or not. But we are on Dual Active System and using Teradata Unity. I heard that we cannot do a insert
into table that got identity col. To overcome this limitation, Teradata suggested to drop only the identity col attribute (NOT THE EXACT IDENTITY
COL) and keep the column and its data.
Geeta Kudumula
TERADATA Certified Master
AMEX IDN TERADATA DBA
|