-
Hi friends,
How do I partition existing Non-partitioned table.
I checked ALTER TABLE syntax. I did not find anything to convert Non-partitioned table into partitioned one.
Any idea?
Thanks in advance
Sam
Sam
-
1. create your partitioned table with 1 partition
2. exchange your non-partitioned table into your partitioned table
3. split the partitioned table to the correct number of partitions
Jeff Hunter
-
1. create your partitioned table with 1 partition
2. exchange your non-partitioned table into your partitioned table
3. split the partitioned table to the correct number of partitions
------------------------------------
My existing table has a lot many database triggers onto the unpartitiond table. Its is the center(child) table of FINANCE system, with lots of header tables onto it.
In this senerio how to workaround?
-
Originally posted by marist89
1. create your partitioned table with 1 partition
2. exchange your non-partitioned table into your partitioned table
3. split the partitioned table to the correct number of partitions
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|