Non-Partition table to Partition
I have a table with about a 2 mil records. Now we want to make this tables partitioned by range on a different tablespace. Since this table being used we would like to do it in a easier way with very minimal downtime (other than exp/imp).Mind you this table has Foreign key and Pk constraints, Please help me out with the startegies/steps involved and drawbacks.
create new table - insert append into new table then rename it and create the constraints
No downtime, you will be actualy doing it online, that is while transactions are going on on that table.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Click Here to Expand Forum to Full Width