| table partitioning [message #59219] |
Wed, 05 November 2003 00:04  |
ramesh
Messages: 123
Registered: August 2000
|
Senior Member |
|
|
hi all,
i have a doubt regarding table partition.
Can we create partitions on an existing table that is having data?, If so, is there any loss of data..
Plz get back at the earliest..
All the replies are welcome...
|
|
|
|
| Re: table partitioning [message #59221 is a reply to message #59219] |
Wed, 05 November 2003 01:02  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
No u cant create partition on existing tables unless that table are partitioned. Means if u have an already partitioned table then u can add more partitions to it but can not convert a unpartitioned table to a partitioned table.
Well if u want to do so then just create a partition table and then insert all the data from ur unpartitioned table to that newly created partitioned table, it will take time according to ur data bu this is the only solution I THINK. And There will be no loss of data.
|
|
|
|
| Re: table partitioning [message #59228 is a reply to message #59219] |
Wed, 05 November 2003 05:56 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
In 9i, you should be able to convert a non-partitioned table into a partitioned table ONLINE using DBMS_REDEFINITION package.
I am yet to try this myself. But its COOL, dont you think ? There shouldnt be any loss of data.
-Thiru
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
