Want to know about save table

Database

Want to know about save table

Hi All,

 I am aware of creating partitions and defining partitions on tables but not sure what actully happens at back when we drop a partition?

I heard all the rows from dropped partion will moved to save table? Is that statement correct? if not what will happen to the existing partition data?

Can someone provide me some more info on that?

Kusuma

Tags (2)
1 REPLY

Re: Want to know about save table

You need to take  precautions with insert into by knowing your data. Know your data well, how it is placed.The link below explains:

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1144_111A/Alte...