Partitions [message #658929] |
Sun, 01 January 2017 06:04 |
|
bheemasql
Messages: 1 Registered: January 2017
|
Junior Member |
|
|
We have history_details table it contains (365*3) 1095 Range partitions (from 01-01-2016 to 31-12-2016) and Maxvalue partition.
i need to split max partition as (365*3) 1095 Range partitions (from 01-01-2017 to 31-12-2017).
i am following ALTER TABLE HISTORY_DETAILS PARTITION DND_MAXPART AT(.....
in this approach it will take each partition 8mb tablespace (it is taking empty rows partition also).
Note: maxpartition having large no of data.
can u tell me any solution for reclaim usage
|
|
|
|
Re: Partitions [message #658931 is a reply to message #658930] |
Sun, 01 January 2017 07:37 |
Solomon Yakobson
Messages: 3275 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
Michel Cadot wrote on Sun, 01 January 2017 07:25
Anyway, the best way for you should be to go to INTERVAL partitioning and no more care about all this.
As long as "Maxvalue partition" is empty and can be dropped. Otherwise it will be a bit more complex.
SY.
|
|
|
Re: Partitions [message #658953 is a reply to message #658929] |
Mon, 02 January 2017 01:44 |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
I wonder how others were able to find out your demand as I cannot deduce it from your post.
Firstly, from 11.2.0.2, the empty partitions may not occupy any physical space.
http://docs.oracle.com/database/122/SQLRF/CREATE-TABLE.htm#GUID-F9CE0CC3-13AE-4744-A43C-EAC7A71AAAB6__CEGBDDBC
Did you really check the space occupied by those "each partition 8mb tablespace"? How?
Are you really using Oracle version 12c? Which exact one?
Was the table created with explicit SEGMENT CREATION IMMEDIATE?
Does the table hit another its restrictions (e.g. is it in SYSTEM tablespace)?
Then, you write about "maxpartition having large no of data".
And, as the last sentence is evidently cut in the middle, it is not clear to me, "reclaim usage" of what you want/expect - those empty(?) new partitons or the partition for MAXVALUE?
Or is it referring to something else than the space occupied by partitions?
|
|
|
|