All Forums Teradata Applications
rohit.lalwani1 8 posts Joined 08/13
28 Aug 2014
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

Raja_KT 1246 posts Joined 07/09
28 Aug 2014
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
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.