| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 7.3.4 -> 8.1.6: Upgrade/Migrate? Or Install/Import
We are currently still running on Oracle 7.3.4.5.0 on Solaris 2.6, and are
planning to upgrade to Oracle 8.1.6, and possibly upgrading the OS to 2.7
also in the process, sometime in the near future. I wanted to throw a
feeler out to get people's opinion on what would be the easiest, most
painless way to accomplish this. I've read the installation and migration
manuals, and it doesn't sound overly difficult to do, but I know that a lot
of you out there have a lot more experience with this than we do, and was
wondering what would be best for us between the following two choices:
Option 1) Migrate the database by using the Oracle Migration tool (of course backing everything up first).
Option 2) Backup server, Export full database, remove Oracle from the system completely, do a clean install of Oracle 8.1.6, then import the data into the new database.
Part of this project is going to include a re-organization of our tablespaces, as we now have a few additional hard drives to use, and would like to spread things out a little better to improve performance by reducing disk contention. That part of the project was why I thought that it might just be easier to go with Option 2 instead.
Of course I am also open to any other options anybody might have as well. Any and all advice would be greatly appreciated, and thanks in advance.
SSgt Robert D. Yexley
Air Force Institute of Technology
Applications Services Division (SCA)
-- Oracle Database Programmer/Administrator -- Configuration Management Officer -- Microsoft Certified Professional
<)))><
From: "Rajendran, Srini" <SRAJENDRAN_at_nlfs.com>
Date: Thu, 16 Nov 2000 09:50:16 -0500
Subject: RE: Redo a Tablespace
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.
------_=_NextPart_001_01C04FDC.886C1D00
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: 7bit
Thank you,
Srini
-----Original Message-----
From: Burton, Laura L. [mailto:BurtonL_at_prismplus.com]
Sent: Wednesday, November 15, 2000 2:22 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Redo a Tablespace
It's attached!!
Laura
-----Original Message-----
From: Rajendran, Srini [mailto:SRAJENDRAN_at_nlfs.com]
Sent: Wednesday, November 15, 2000 11:11 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Redo a Tablespace
Please.
-----Original Message-----
From: Burton, Laura L. [mailto:BurtonL_at_prismplus.com]
Sent: Wednesday, November 15, 2000 10:11 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Redo a Tablespace
It comes from an article 'How to Stop Defragmenting and Start Living: The Definitive Word on Fragmentation' by B. Himatsingka and J. Loaiza from the Oracle Corporation.
SAFE = Simple Algorithm for Fragmentation Elimination
I made a script which contain queries for the rules referenced in the article. I'll send it to you if you want it.
Laura
------_=_NextPart_001_01C04FDC.886C1D00
Content-Type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <TITLE>RE: Redo a Tablespace</TITLE> <META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD><BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=107385614-16112000>Srini </SPAN></FONT></DIV> <BLOCKQUOTE style="MARGIN-RIGHT: 0px">
 |
 |