Partitions on Existing TD 14.10 table

Teradata Applications
Enthusiast

Partitions on Existing TD 14.10 table

Hi

I have a table which has approx 7.8 million records there is no partition on table as o now.

We have to create a partition on date column (posting date). Is that possible to create on existing table or we have to create a new table with patitions on it and then copy data or rename it ?

Please advice

1 REPLY
Enthusiast

Re: Partitions on Existing TD 14.10 table

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1184_111A/Alter_Function-Details.008.088.html#ww16787434

You can see the link here and also the consequence  that may come up