Home » RDBMS Server » Performance Tuning » Split partitions in oracle 8.0.4.3 (Sun solaris 5.9)
Split partitions in oracle 8.0.4.3 [message #292452] Tue, 08 January 2008 23:51 Go to next message
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

Re: Split partitions in oracle 8.0.4.3 [message #292455 is a reply to message #292452] Wed, 09 January 2008 00:03 Go to previous messageGo to next message
BlackSwan
Messages: 25035
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).
Re: Split partitions in oracle 8.0.4.3 [message #292457 is a reply to message #292455] Wed, 09 January 2008 00:10 Go to previous messageGo to next message
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
Re: Split partitions in oracle 8.0.4.3 [message #292462 is a reply to message #292452] Wed, 09 January 2008 00:28 Go to previous messageGo to next message
BlackSwan
Messages: 25035
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.
Re: Split partitions in oracle 8.0.4.3 [message #292465 is a reply to message #292452] Wed, 09 January 2008 00:33 Go to previous messageGo to next message
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 ...


Re: Split partitions in oracle 8.0.4.3 [message #292495 is a reply to message #292465] Wed, 09 January 2008 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Split partitions in oracle 8.0.4.3 [message #292792 is a reply to message #292495] Wed, 09 January 2008 20:55 Go to previous message
rleishman
Messages: 3724
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
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:
  


Current Time: Sat Dec 03 16:24:26 CST 2016

Total time taken to generate the page: 0.16040 seconds