OraFAQ Forum: Performance Tuning » Split partitions in oracle 8.0.4.3

Home » RDBMS Server » Performance Tuning » Split partitions in oracle 8.0.4.3 (Sun solaris 5.9)

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

Split partitions in oracle 8.0.4.3 [message #292452]

Tue, 08 January 2008 23:51

hitenparekh
Messages: 5
Registered: January 2008

Junior Member

Hi all ,
i already have tables wid range partitions .. i want to split my last partitions which has upperbound "MAXVLUE" partition ... my doubts are wheter splitting partitions will effect on
1. Global Indexes
2. LOcal INDEXES
3. Integrity Constraints
4. Procedures and Functions
5. Applications
6. Data Loss

P.S i m using TOAD 7.3.0.0 utility for splitting partitions ...

TIA
Parekh Hiten

Report message to a moderator

Re: Split partitions in oracle 8.0.4.3 [message #292455 is a reply to message #292452]

Wed, 09 January 2008 00:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>oracle 8.0.4.3
So many problems....
I doubt oracle 8.0.4.3 was ever certified on Solar 5.9.
IIRC, Solaris was at V5.7 when Oracle V8.0 was released.
If you say that Oracle had partitioning with V8.0, I'll believe you but I do not explicitly recall it.
Of course I am old & going senile, so it may be true.
I do believe that unless & until you can totally empty the MAXVALUES/HIGHVALUES partition you are stuck between a rock & a hard spot.

This is one of the prices you pay for not staying current.
Sooner or later you will pay the price for upgrading (or not).

Report message to a moderator

Re: Split partitions in oracle 8.0.4.3 [message #292457 is a reply to message #292455]

Wed, 09 January 2008 00:10

hitenparekh
Messages: 5
Registered: January 2008

Junior Member

Thanks for ur reply ..

even i have benn syaing them to upgrade but they don't want to ,
so eliminate that option ,

but can u please wid ma indexes , fuctions and procedures ...

or any other alternate solutions tahn splitting the table ... like creating new table then moving the table data into new one etc ...

Parekh Hiten

Report message to a moderator

Re: Split partitions in oracle 8.0.4.3 [message #292462 is a reply to message #292452]

Wed, 09 January 2008 00:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>so eliminate that option
Ok, upgrade is not an option.
So why are we having this discussion?
Just keep adding new records to the uppermost partition
& hope you retire before "they" pay the price for not upgrading.

Report message to a moderator

Re: Split partitions in oracle 8.0.4.3 [message #292465 is a reply to message #292452]

Wed, 09 January 2008 00:33

hitenparekh
Messages: 5
Registered: January 2008

Junior Member

> i will for sure retire before that situation ...
but as of now will the splitting effect on my database ...
plwase help wid this ...

Report message to a moderator

Re: Split partitions in oracle 8.0.4.3 [message #292495 is a reply to message #292465]

Wed, 09 January 2008 01:21

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Please read and follow OraFAQ Forum Guide, especially about IM speak.

Then Oracle documentation explains what happens when you split, you just have to find and read 8.0 doc.

Regards
Michel

Report message to a moderator

Re: Split partitions in oracle 8.0.4.3 [message #292792 is a reply to message #292495]

Wed, 09 January 2008 20:55

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Michel Cadot wrote on Wed, 09 January 2008 18:21

Then Oracle documentation explains what happens when you split, you just have to find and read 8.0 doc.

And here it is:
http://download.oracle.com/docs/cd/A64702_01/doc/server.805/a58225/ch4a.htm#1986728

Ross Leishman

Report message to a moderator

Previous Topic:	retrieve execution plan for running session in Oracle 8i database
Next Topic:	What can I do to increase my Library Cache Hit stats

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 10:13:05 CDT 2024