Archives of the TeradataForum
Message Posted: Sat, 24 Jan 2009 @ 17:12:34 GMT
How can I modify my table to modify (or add) the partition,
I know other way of doing this is by creating the table then inserting the rows back,
For some reason, I don't want to recreate it, but instead modify the partition.
I tried some "alter table ... partition add.." SQL, but unable to. Help from experts is greatly appreciated.
The New partition should look like this:
PARTITION BY RANGE_N(ywkno BETWEEN 200801 AND 200852 EACH 1, 200901 AND 201052 EACH1 );
Current table definition is this:
CREATE MULTISET TABLE X ( a CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, ywkno INTEGER NOT NULL) PRIMARY INDEX ( a ) PARTITION BY RANGE_N(ywkno BETWEEN 200801 AND 200852 EACH 1 );
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|