Home » RDBMS Server » Server Utilities » 10g to 8i
10g to 8i [message #197475] Wed, 11 October 2006 06:39 Go to next message
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
Re: 10g to 8i [message #201481 is a reply to message #197475] Sat, 04 November 2006 14:54 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
What do You mean by "downward compatible" ???
Re: 10g to 8i [message #201508 is a reply to message #197475] Sun, 05 November 2006 06:56 Go to previous messageGo to next message
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.
Re: 10g to 8i [message #201514 is a reply to message #201508] Sun, 05 November 2006 07:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: 10g to 8i [message #201726 is a reply to message #201514] Mon, 06 November 2006 09:18 Go to previous message
joy_division
Messages: 4644
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:
  


Current Time: Sat Dec 10 16:47:39 CST 2016

Total time taken to generate the page: 0.08433 seconds