converting Normal Table to Partitioned Table [message #381636] |
Mon, 19 January 2009 01:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
abs_amit
Messages: 59 Registered: January 2006 Location: delhi
|
Member |
|
|
Hi,
i want to convert one normal Table (size 160 GB) to Partitioned table. this table has around 16 months data and new table will be having partition for each month.
please suggest what is the best approach to do that, as size is the only concern here. so how to overcome on that ?
I am thinking about below aproaches:
1. Export- import
2. Create new table (partitioned) and insert data
3. ALTER TABLE <> EXCHANGE PARTITION
Thanks and Regards
Amit Yadav
|
|
|
|
Re: converting Normal Table to Partitioned Table [message #381650 is a reply to message #381641] |
Mon, 19 January 2009 02:20 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
abs_amit
Messages: 59 Registered: January 2006 Location: delhi
|
Member |
|
|
Thanks Michel,
we have enough space in database. but we can not use "nologgin" because we have DR database. we can also afford downtime.
1. why 3rd option is not possible? (please check the attached file having detail about the same)
2. So out of possible four approaches, which one is the best (fastest and safest) ?
3. what would you suggest?
Regards
Amit
-
Attachment: TIP05.txt
(Size: 1.27KB, Downloaded 1300 times)
[Updated on: Mon, 19 January 2009 02:27] Report message to a moderator
|
|
|
|