Creating partition on existing table.
RaghuSep 2 2011 — edited Sep 2 2011Is it possible to ceate a partition on exsisting table and apply partition on already existing records.
The work around i am using is to create a backup table witj\h same structure and schema. And creating partitions on backup table. Once done I am loading back the data from original table. Oce data loaded, Drop original table and a rename backup table as original table.
Is there any other way to achieve my goal?