Oracle8.17 & Oracle9.0.2 Compatibility question

[65]

Hi All,

When using export/import utilities to transfer data between two different versions of databases. (Oracle9i & 8i), I need to reset the compatible initialization parameter in Oracle 9.0.2. Just wanted to know whether I do need to downgrade my Oracle9.0.2 database server to release 8.1.7 in order to make it compatible with my client's server or not? Since I only need to export a dump file to transfer to the remote client.

I plan to set up a brand new Oracle9.0.2 server very soon. Just wanted to seek your good advice of which version of oracle (9.0.2 or 8.1.7) I should go for. Since I read the documentation on this link

http://otn.oracle.com/docs/products...lease2/server.920/a96530/downgrad.htm#1008879

and found that it is not fun at all to downgrade the entire Oracle9.0.2 in order to work with my remote Oracle8.1.7 server. Please direct me what to do. Your help is greatly appreciated.

Thanks in advance.

Lenka

 

[Turkbear]

Hi,
I do not think you need to reset anything in the 9i database to accept imports from an 8.1.7 one;
Use the 8.1.7 export tool to create the dmp file and then import it into the 9i .

The 8.1.7 client software will work with 9i databases so you do not need to change your clients, but,if you can, you may want to since the 9i client can access all 8.+ versions
of the database.

The versions of Oracle ( except v7 and earlier) work well together, so you do not need to downgrade any existing 9i or, for that matter, upgrade any 8.x except for its eventual loss of support.

 

Hi Turkbear,

Thanks for your quick response. I do appreciate it very much. You meant that I don't need to DOWNGRADE my Oracle 9.0.2 database to 8.1.7 because I can use Import/export utilities to transfer data between TWO DIFFERENT VERSIONS OF DATABASES. Sorry I confused you in the previous message. Since my client is currently using Oracle8.1.7 server while I plan to set up a brand new oracle9.0.2 one. there is huge data that needs to be loaded into the Oracle9.0.2 server before it will be transferred to the Oracle8.1.7 database (using export utility to do so). Here is my concern is it ok to work between two different versions of databases?

Thanks in advance

Lenka

 

[Turkbear]

The rule is to use the lower version of Export if exporting from a higher version than your import target..
So if you load the data into the 9.0.2 server then you will need to use the 8.1.7 Export utility to create the dmp file that will be IMPorted into the 8.1.7 database.
( Any 9.0.2 specific objects will not be exported )

 

Hi Turkbear,

Thanks for your input. I do appreciate it. Like you said "Any 9.0.2 specific objects will not be exported, so the compatible issues need to be concerned. Such as tables containing LOBs and objects will not be exported when I've specified a direct path load. (DIRECT = Y, objects whose DDL is implemented as a stored procedure ratehr than SQL are not exported etc... In this case, when using Import/Export utility to tranfer data between 2 different versions of oracle, the incompatible is an issue. I've read some Export/Import documentation and learn that some features will not be supported when using Export release 8.0 on an oracle 9i database. Thus, in order to solve the compatibility problems, oracle8.1.7 is a perfect match with my client's Oracle8.1.7 server site. Unfortunatly, I am not a person who can make a decision. Any suggestion if my boss still wants to go with the latest version of oracle.?

Any help is greatly appreciated.

Lenka

 

[Turkbear]

Direct path is not supported if different versions of the database are involved - use conventional instead..

V8.x and above had CLOB and BLOB and NCLOB data types
so exp/imp should be ok..
BTW, export 8.0.x is not the same as 8.1.x.

Since your target is an 8.1.7 database you will not want 9.x specific features to be included..If the client does not want to upgrade to 9.x then be sure you do not use any 9.x ONLY stuff in the data you are loading for them.

 

Hi Turkbear,

Thanks for your input and quick response. I do appreciate it.
Have a good evening.

Lenka

 

[Sachinkhare]

take a export of 9i tables using 8i export utility
e.g.
export userid = scott/tiger@xyz + other parameters required for export.
where scott/tiger is username /password of 9i user and xyz is the TNS service name for connecting to 9i database.
run this export utility in 8i

 

Hi Sachinkhare,

Thanks for your input. Your help is great appreciated.

Have a good day.

Lenka