OraFAQ Forum: Server Utilities » Downgrade 9i to 8i

Home » RDBMS Server » Server Utilities » Downgrade 9i to 8i

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

Downgrade 9i to 8i [message #73169]

Tue, 24 February 2004 23:48

Abiad
Messages: 9
Registered: October 2003

Junior Member

Hi all,

Is there any recommandation to downgrade a database from 9i to 8i (Unix systems) ? (Reason : Some PL/SQL programs don't have the same behaviour)

Think copying all datafiles + control files, etc is not recommanded !

Thanks for help

Yhab

Report message to a moderator

Re: Downgrade 9i to 8i [message #73170 is a reply to message #73169]

Wed, 25 February 2004 02:59

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

Read chapter 7 of the Oracle9i Database Migration
Release 2 (9.2) Guide: Downgrading a Database Back to the Previous Oracle Release.

Best regards.

Frank

Report message to a moderator

Re: Downgrade 9i to 8i [message #73171 is a reply to message #73169]

Wed, 25 February 2004 03:02

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

Senior Member
Account Moderator

i beleive a scripted method is to use d0801070.sql( a little tedious stuff)
Much simpler method is to an export and import .
But this is really not a fix.
AT any point of , u need to upgrade your database.
SO try fixing the PL/SQL routines.
There are a few changes from 8i to 9i ( utl_File) etc.

Report message to a moderator

Previous Topic:	Connect message in CONNECT command
Next Topic:	how to upload date fied using sql*loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 02:22:08 CDT 2024