Can we add partition to a table which has data? I read online about exchange partition..
1) We have a table old_tab (without partition but has data)
2) Create a table new_tab same as old_tab but with partitions
3)Switch data from old_tab to new_tab using alter table....
ALTER TABLE new_tab
EXCHANGE PARTITION partition_name
WITH TABLE old_tab
4) Drop the old table(old_tab) and rename the new table(NEW_TAB) as old table(OLD_TAB).