OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » 10g to 8i

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

10g to 8i [message #197475]

Wed, 11 October 2006 06:39

frank.svs
Messages: 162
Registered: February 2006

Senior Member

Hi Frns,

I need u r suggestions. Assume that i have data in Oracle 10g database server and my requirement is that i wanted to make the data as downward compatible with oracle 8i database. Any anyone give some inputs.

Thanks in advance,
frank

Report message to a moderator

Re: 10g to 8i [message #201481 is a reply to message #197475]

Sat, 04 November 2006 14:54

kimant
Messages: 201
Registered: August 2006
Location: Denmark

Senior Member

What do You mean by "downward compatible" ???

Report message to a moderator

Re: 10g to 8i [message #201508 is a reply to message #197475]

Sun, 05 November 2006 06:56

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

if you want to transfer data from oracle 8i to oracle 10g.
then use original import or export utilities.
it is better option for you.

hope this helps.
Mohammad Taj.

Report message to a moderator

Re: 10g to 8i [message #201514 is a reply to message #201508]

Sun, 05 November 2006 07:30

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

Senior Member
Account Moderator

>> i wanted to make the data as downward compatible with oracle 8i database.
Correct term is 'backward compatible'.
IMHO, data is just data. In most cases Data is just compatible.
But not the options/features/code that is using the data.
What particular options/feautres are you looking into?
For example you may want to stick to 8i based CBO options.
Look here
http://orafaq.com/parms/parm159.htm
Please be advised that, setting compatible to a lower version disables many vital features in higher version
and should be done only with advice from OSS.

But, i you want to 'downgrade' the database from 10g to 8i ( as opposed to 'upgrade')
then export/import method explained by User52 should work.
Beware that upgrade/downgrade using export/import will work good only if the database is simple without any advanced options. Because with these you just moving the data (and associated code) around.
You are NOT really 'upgrading' the code. Some pl/sql coding features may not be available in lower versions and vice-versa.

Report message to a moderator

Re: 10g to 8i [message #201726 is a reply to message #201514]

Mon, 06 November 2006 09:18

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

I hope someone other than Frns is allowed to answer. And I am not quite sure what type of suggestion a u r is, but...

You do know of course that you must use the exp from the lower version of the database if you are planning to move it from 10g to 8i.

[Updated on: Mon, 06 November 2006 09:18]

Report message to a moderator

Previous Topic:	sqlldr error
Next Topic:	IMP-00009: abnormal end of export file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 15:54:30 CDT 2024