473,385 Members | 1,707 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

O8 reorganization or O9 upgrade - which first?

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?
Jul 19 '05 #1
3 2420
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

Jul 19 '05 #2
It would be nice, but have anyone done it?
Or it's just a tought?!
"Frank van Bortel" <fv********@netscape.net> wrote in message
news:cg*********@news5.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

Jul 19 '05 #3
Njofra wrote:
It would be nice, but have anyone done it?
Or it's just a tought?!
"Frank van Bortel" <fv********@netscape.net> wrote in message
news:cg*********@news5.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

Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Tappy Tibbons | last post by:
Have many of you upgraded to VS 2003? We have been using Visual Studio 2002, and are somewhat satisfied, except for the following areas: Speed - VS2002 apps are dead dog slow to start up, and...
1
by: DickChristoph | last post by:
Hi I am interested in converting a Access 97 application to VB.Net (well okay rewriting). This would be a VB.Net client with a SQL Server backend, as opposed to my other alternative which would...
2
by: Matt | last post by:
Hello All I have SQL Server versions 6.5 and 2000 installed on a Windows 2000 server. I installed 6.5 first, coppied a backup of a database to the server and restored it. I then installed...
36
by: Tim | last post by:
Is there a way to upgrade from Visual C++ Net 2002 to Visual C++ Net 2003? The 2002 version does not provide a Windows Forms Designer. I can't find any upgrade package on Microsoft's website. ...
6
by: Joseph Geretz | last post by:
I recently upgraded my server to Windows 2003. The first thing I noticed is that my sample WebService pages no longer worked. The Invoke test button is missing. This is addresed by the following KB...
2
by: vrush | last post by:
Please tell me about reorganization in file structure?
0
by: lazydba | last post by:
Hi, I installed the evaluation copy on a server, the eval license expired, and now I'm trying upgrade to a retail version. I have read the docs http://support.microsoft.com/kb/914158/en-us and...
3
by: Njofra | last post by:
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...
3
by: Mark D Powell | last post by:
I attempted to upgrade my SQL Server 2000 Enterprise Edition (32 bit) to SQL Severer 2005 EE 32 bit and while the prereqs passed the installer will not let me select the version 8.00.x (2000 SP4)...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.