RE: backwards export
Title: RE: backwards export I'm not sure of the export compatibility, but you should know that 9i clients won't talk to a 7.3.4 database, True and 7.3.4 clients won't talk to a 9.2 database, False A Oracle7 client can, will, and does talk to a 9.2.0 database with no problem. which could be a problem. At least, they're not certified to talk to each other, which isn't quite the same thing. See note 172179.1 on Metalink. To quote: In short, any version of SQL*Net's version 2 Client (2.3.x) and up to Net 9.0.x, will be able to connect to any version of Oracle Database version 7.3.x and up to 9.2.x, with certain compatibility issues that are explained below Matt Adams Matt Adams - GE Appliances - [EMAIL PROTECTED] It will make sense when you stop thinking logically, and start thinking Oracle-ly - Jim Droppa -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 23, 2003 8:55 AM To: Multiple recipients of list ORACLE-L Subject: Re: backwards export I'm not sure of the export compatibility, but you should know that 9i clients won't talk to a 7.3.4 database, and 7.3.4 clients won't talk to a 9.2 database, which could be a problem. At least, they're not certified to talk to each other, which isn't quite the same thing. Cheers Simon Anderson Jeroen van Sluisdam [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23/07/2003 12:49 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: backwards export Hi, We are investigating possibilities for migration of an oracle 7.3.4 to oracle 9i. We want to separate our production DB from the app-logic such that we can migrate from oracle 7.3.4 on hp-ux 10.20 to oracle 9i on hp-ux 11. Problem is our development and test-environment because we cannot separate the logic at the same time here also from the db (costs). Does anyone have any experience with exporting from oracle 9i to oracle 7.3.4 ? I found the underlying note on metalink about the same problem but with oracle 8. I have limited experience on oracle8 and none on oracle 9. So I hope you can give some tips. .. You need to run the 7.3 version of export against your 8.0 database via sqlnet/net8. Beforehand, you need to run rdbms/admin/catexp7.sql against your 8.0 database. This creates the 7.3 export views required. Note that if you have used any 8.0 specific features (e.g. objects) these will not be exported for obvious reasons. Tia, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backwards export
and 7.3.4 clients won't talk to a 9.2 database, False This is sort-a false. If the 9.2 database is in a new characterset such as UTF8, the old sqlnet clients will have difficulties if the client machine is also not in UTF8. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] E.COMTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: backwards export .com 07/24/2003 10:14 AM Please respond to ORACLE-L I'm not sure of the export compatibility, but you should know that 9i clients won't talk to a 7.3.4 database, True and 7.3.4 clients won't talk to a 9.2 database, False A Oracle7 client can, will, and does talk to a 9.2.0 database with no problem. which could be a problem. At least, they're not certified to talk to each other, which isn't quite the same thing. See note 172179.1 on Metalink. To quote: In short, any version of SQL*Net's version 2 Client (2.3.x) and up to Net 9.0.x, will be able to connect to any version of Oracle Database version 7.3.x and up to 9.2.x, with certain compatibility issues that are explained below Matt Adams Matt Adams - GE Appliances - [EMAIL PROTECTED] It will make sense when you stop thinking logically, and start thinking Oracle-ly - Jim Droppa -Original Message- Sent: Wednesday, July 23, 2003 8:55 AM To: Multiple recipients of list ORACLE-L I'm not sure of the export compatibility, but you should know that 9i clients won't talk to a 7.3.4 database, and 7.3.4 clients won't talk to a 9.2 database, which could be a problem. At least, they're not certified to talk to each other, which isn't quite the same thing. Cheers Simon Anderson Jeroen van Sluisdam [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23/07/2003 12:49 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:backwards export Hi, We are investigating possibilities for migration of an oracle 7.3.4 to oracle 9i. We want to separate our production DB from the app-logic such that we can migrate from oracle 7.3.4 on hp-ux 10.20 to oracle 9i on hp-ux 11. Problem is our development and test-environment because we cannot separate the logic at the same time here also from the db (costs). Does anyone have any experience with exporting from oracle 9i to oracle 7.3.4 ? I found the underlying note on metalink about the same problem but with oracle 8. I have limited experience on oracle8 and none on oracle 9. So I hope you can give some tips. .. You need to run the 7.3 version of export against your 8.0 database via sqlnet/net8. Beforehand, you need to run rdbms/admin/catexp7.sql against your 8.0 database. This creates the 7.3 export views required. Note that if you have used any 8.0 specific features (e.g. objects) these will not be exported for obvious reasons. Tia, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net
Re: backwards export
I'm not sure of the export compatibility, but you should know that 9i clients won't talk to a 7.3.4 database, and 7.3.4 clients won't talk to a 9.2 database, which could be a problem. At least, they're not certified to talk to each other, which isn't quite the same thing. Cheers Simon Anderson Jeroen van Sluisdam [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23/07/2003 12:49 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:backwards export Hi, We are investigating possibilities for migration of an oracle 7.3.4 to oracle 9i. We want to separate our production DB from the app-logic such that we can migrate from oracle 7.3.4 on hp-ux 10.20 to oracle 9i on hp-ux 11. Problem is our development and test-environment because we cannot separate the logic at the same time here also from the db (costs). Does anyone have any experience with exporting from oracle 9i to oracle 7.3.4 ? I found the underlying note on metalink about the same problem but with oracle 8. I have limited experience on oracle8 and none on oracle 9. So I hope you can give some tips. .. You need to run the 7.3 version of export against your 8.0 database via sqlnet/net8. Beforehand, you need to run rdbms/admin/catexp7.sql against your 8.0 database. This creates the 7.3 export views required. Note that if you have used any 8.0 specific features (e.g. objects) these will not be exported for obvious reasons. Tia, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backwards export
Jeroen I haven't done this specific export/import. Hopefully someone who has will respond. The usual prescription is to use the exp binary from the older Oracle version to export the data. The layout of the data files changed between Oracle 7 and Oracle 8, but did not change from 8 to 9, so you might specifically look for instructions on moving data from 8 back to 7. I have seen people on this list that have done that. You might also start considering how you will confirm data integrity after the data movement. Audit your data to see which data types you use. In the worst case, you might have to install an Oracle 8 or 8i instance and move the data in two steps. Hopefully it won't come to that. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 6:49 AM To: Multiple recipients of list ORACLE-L Hi, We are investigating possibilities for migration of an oracle 7.3.4 to oracle 9i. We want to separate our production DB from the app-logic such that we can migrate from oracle 7.3.4 on hp-ux 10.20 to oracle 9i on hp-ux 11. Problem is our development and test-environment because we cannot separate the logic at the same time here also from the db (costs). Does anyone have any experience with exporting from oracle 9i to oracle 7.3.4 ? I found the underlying note on metalink about the same problem but with oracle 8. I have limited experience on oracle8 and none on oracle 9. So I hope you can give some tips. .. You need to run the 7.3 version of export against your 8.0 database via sqlnet/net8. Beforehand, you need to run rdbms/admin/catexp7.sql against your 8.0 database. This creates the 7.3 export views required. Note that if you have used any 8.0 specific features (e.g. objects) these will not be exported for obvious reasons. Tia, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).