Re: How to Partition an existing table

There are 3 steps involved to achive it as follows:

1. analyze your data in the existing table and decide which type of
partition is suitable to your data.  if your table has 5 years of data in it
then create a partition table containing 5 paritions (part_year96,
part_year97, part_year98, part_year99, part_year2000) based on range
partitioning -- on yearly basis.

2. load the data in each respective partion as follows:

insert into table customer partition part_year96
select * from customer where year='1996';
commit;

 insert into table customer partition part_year97
select * from customer where year='1997';
commit;

 insert into table customer partition part_year98
select * from customer where year='1998';
commit;

 insert into table customer partition part_year99
select * from customer where year='1999';
commit;

 insert into table customer partition part_year2000
select * from customer where year='2000';
commit;

3. drop table customer;

if required, create partition indexes on all the partition.

Have fun.


On Wed, Nov 26, 2008 at 11:22 PM, khabeer khayyam <khabeer1983@xxxxxxxxx>wrote:

> Can anybody plz tell me how to partition an existing table.
>
>
> Thanks,
>
> Regards,
>
> Khayyam
>
>
>  ------------------------------
> Connect with friends all over the world. Get Yahoo! India 
> Messenger.<http://in.rd.yahoo.com/tagline_messenger_1/*http://in.messenger.yahoo.com/?wm=n/>
>
>

Other related posts: