Altering the partitioning of a non-empty table

General
Teradata Employee

Altering the partitioning of a non-empty table

Hi,

Anyone knows what cause this problem and how to fix it:

« The facility of altering the partitioning of a non-empty table in this case has not been implemented yet »

Please help......

Thanks

2 REPLIES
Junior Supporter

Re: Altering the partitioning of a non-empty table

The partitioning is made on the primary index, which is the basement of the table distribution throught the AMPs.

You can create another table with the desired partitioning schema and INSERT...SELECT from the old table, then drop it and, if necessary, rename the new table as the old one.

HTH.

Cheers.

Carlos.

Teradata Employee

Re: Altering the partitioning of a non-empty table

Many thanks CarlosAl..................