Archives of the TeradataForum
Message Posted: Tue, 19 Apr 2005 @ 14:07:37 GMT
I am trying to create a PPI table as given below.
CREATE TABLE Simple (a INT, b INT, c INT) UNIQUE PRIMARY INDEX (a,b) PARTITION BY RANGE_N (c BETWEEN 1 AND 100 EACH 10);
This gives an error UNIQUE is not allowed . I don't know how partitioning column is afftecting the UNIQUE ness of PI? Any reasons?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|