partitioning tables [message #37948] |
Thu, 07 March 2002 23:34 |
krishna
Messages: 141 Registered: October 1998
|
Senior Member |
|
|
what is the syntax for partitioning a table that has already been created(without partitions) and also has been filled with data?
|
|
|
Re: partitioning tables [message #37949 is a reply to message #37948] |
Fri, 08 March 2002 01:23 |
Manoj
Messages: 101 Registered: August 2000
|
Senior Member |
|
|
If a table is exist in database without Partitioning then u cannot add a partition with it.
so rename existing table create a table with partition option and transfer data from rename table to new one.
|
|
|
Re: partitioning tables [message #39017 is a reply to message #37948] |
Thu, 06 June 2002 14:27 |
Jeff
Messages: 63 Registered: July 1999
|
Member |
|
|
You cannot partition a non-partitioned table. You need to do the following:
1) Create a table just like your non-partitioned table, but with the partitions you want.
2) Populate the new, partitioned table with the data from the old, non-partitioned table.
3) Drop the old table.
4) Rename the new table to have the same name as the old one.
|
|
|