OraFAQ Forum: Server Administration » Split partition notes

Home » RDBMS Server » Server Administration » Split partition notes (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Split partition notes [message #675850]

Tue, 23 April 2019 23:16

fabi88
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.

Report message to a moderator

Re: Split partition notes [message #676002 is a reply to message #675850]

Sun, 05 May 2019 23:39

trantuananh24hg
Messages: 744
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.

Report message to a moderator

Re: Split partition notes [message #676016 is a reply to message #676002]

Tue, 07 May 2019 04:01

cookiemonster
Messages: 13963
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.

Report message to a moderator

Previous Topic:	TNS-01151 - problem with starting the listener for standby database
Next Topic:	Partitioning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 10:35:10 CST 2025