OraFAQ Forum: Server Administration » Upgrade of oracle 8i db

Home » RDBMS Server » Server Administration » Upgrade of oracle 8i db

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

Upgrade of oracle 8i db [message #180529]

Tue, 04 July 2006 01:54

prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai

Member

Hi all,

We are planning to upgrade our database from oracle 8.1.7.4 to 10gR2.

But we have a confusion that whether v has to go by

a.Manual Upgrade method or
b.Exp/Imp method.

we feel there are some advantages and disadvantages in both the method.

Our database is dictionary managed tablespace not locally managed tablespace. so we feel whether it will cause fragmentation problems if we go for Manual upgrade method. At the same time we dont have enough space in server to proceed with EXP/IMP method.

The details are below:

Db version: Oracle 8 1 7 4
Operating system: Sun os 5.8 version
Db size : 70 gb
Planned db to upgrade: 10g R2

Pleas explain and suggest which method to proceed further?

Expecting your replies.

Thanks,

Prashanth

Report message to a moderator

Re: Upgrade of oracle 8i db [message #180551 is a reply to message #180529]

Tue, 04 July 2006 03:17

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Use a share or NFS mount to dump data from database (exp/imp).
70 Gb is not-so-big ( Still export /import method will take some time).
All your options are discussed here
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm

Report message to a moderator