Home » RDBMS Server » Server Administration » Split partition notes (Oracle 11g)
Split partition notes [message #675850] Tue, 23 April 2019 23:16 Go to next message
Messages: 112
Registered: November 2011
Senior Member
Hi experts,

there is a partitioned table that is going to be split to new partitions in Oracle 11g version. the size of table is 60G. what notes should be considered before start splitting? do we need 60G extra volume during splitting operation? and something else?.

thank you in advance.
Re: Split partition notes [message #676002 is a reply to message #675850] Sun, 05 May 2019 23:39 Go to previous messageGo to next message
Messages: 742
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
You should better to give us more information, ex: What's logical table purpose? How long to grow? How many columns and data-type was identified in which column?
You should not tell us: I want to change my car from Toyota to Porsche, should I? It's yours, not our.
Re: Split partition notes [message #676016 is a reply to message #676002] Tue, 07 May 2019 04:01 Go to previous message
Messages: 13904
Registered: September 2008
Location: Rainy Manchester
Senior Member
This question is actually much more specific than that.
It's asking how much disk space is needed for the split operation itself.
The main question that needs asking is - how is it split now and how is it going to be split.
Previous Topic: TNS-01151 - problem with starting the listener for standby database
Next Topic: Partitioning
Goto Forum:

Current Time: Thu Mar 30 06:32:29 CDT 2023