dbTalk Databases Forums  

O8 reorganization or O9 upgrade - which first?

comp.databases.oracle comp.databases.oracle


Discuss O8 reorganization or O9 upgrade - which first? in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Njofra
 
Posts: n/a

Default O8 reorganization or O9 upgrade - which first? - 08-25-2004 , 07:12 AM






We are running SAP 4.6C with Oracle 8.1.7 with huge database (800GB)

We have done some data archiving and relaease some space (150GB) which is
now again almost filled.
Soon we will archive more data and we would like to do data reorganization
(db export/import).
Also we should upgrade to Oracle 9 because of maintenance end (until
December 2004).

Which should we do first: REORG or UPGRADE?



Reply With Quote
  #2  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: O8 reorganization or O9 upgrade - which first? - 08-25-2004 , 10:16 AM






Njofra wrote:
Quote:
We are running SAP 4.6C with Oracle 8.1.7 with huge database (800GB)

We have done some data archiving and relaease some space (150GB) which is
now again almost filled.
Soon we will archive more data and we would like to do data reorganization
(db export/import).
Also we should upgrade to Oracle 9 because of maintenance end (until
December 2004).

Which should we do first: REORG or UPGRADE?


Both at the same time: create a new 9i (release 2 I hope)
instance and database, and import the 8i stuff.
Gets you all the joy of nifty new 9i possibilities.
--

Regards,
Frank van Bortel



Reply With Quote
  #3  
Old   
Njofra
 
Posts: n/a

Default Re: O8 reorganization or O9 upgrade - which first? - 08-26-2004 , 12:15 AM



It would be nice, but have anyone done it?
Or it's just a tought?!


"Frank van Bortel" <fvanbortel (AT) netscape (DOT) net> wrote

Quote:
Njofra wrote:
We are running SAP 4.6C with Oracle 8.1.7 with huge database (800GB)

We have done some data archiving and relaease some space (150GB) which
is
now again almost filled.
Soon we will archive more data and we would like to do data
reorganization
(db export/import).
Also we should upgrade to Oracle 9 because of maintenance end (until
December 2004).

Which should we do first: REORG or UPGRADE?



Both at the same time: create a new 9i (release 2 I hope)
instance and database, and import the 8i stuff.
Gets you all the joy of nifty new 9i possibilities.
--

Regards,
Frank van Bortel




Reply With Quote
  #4  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: O8 reorganization or O9 upgrade - which first? - 08-26-2004 , 01:53 AM



Njofra wrote:
Quote:
It would be nice, but have anyone done it?
Or it's just a tought?!


"Frank van Bortel" <fvanbortel (AT) netscape (DOT) net> wrote in message
news:cgia3f$ml$1 (AT) news5 (DOT) tilbu1.nb.home.nl...

Njofra wrote:

We are running SAP 4.6C with Oracle 8.1.7 with huge database (800GB)

We have done some data archiving and relaease some space (150GB) which

is

now again almost filled.
Soon we will archive more data and we would like to do data

reorganization

(db export/import).
Also we should upgrade to Oracle 9 because of maintenance end (until
December 2004).

Which should we do first: REORG or UPGRADE?



Both at the same time: create a new 9i (release 2 I hope)
instance and database, and import the 8i stuff.
Gets you all the joy of nifty new 9i possibilities.
--

Regards,
Frank van Bortel




I have done it, and other people in c.d.o.server
(where this question belongs - this group id dead)
too.

--

Regards,
Frank van Bortel



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.