Re: Data extraction for Oracle 6.3??

From: Andreas Necker <Andreas.Necker_at_isb-ag.de>
Date: Fri, 27 Apr 2001 15:18:35 +0200
Message-ID: <3AE971AB.BAB5D116@isb-ag.de>

hi,

Niall Litchfield wrote:
>
> This would work, but you'll need an Oracle 7 database and utilities to
> import into IIRC. So in other words to move from 6.3 to 8i would require
> building an intermediate 7.3 database. I'm sure this works in theory but I'd
> be intrigued to see it in practice. I'd go the sql*plus or third party tool
> route suggested by others.
>

have a look at the "COMPATIBILITY MATRIX FOR EXPORT & IMPORT BETWEEN DIFFERENT ORACLE VERSIONS" document on metalink

...
Matrix 2: Which EXPORT utility to use when importing into an Oracle8

           or a higher database release
           (always use IMPORT utility of the target database):

+----------+------------------------------------------------+
|  EXPORT  |                    IMPORT to                   |

| from +------+------+------+------+------+------+------+ | \/ | 8.0.3| 8.0.4| 8.0.5| 8.0.6| 8.1.5| 8.1.6| 8.1.7|  +----------+------+------+------+------+------+------+------+

| 5.x 1) 2)|EXP5x |EXP5x |EXP5x |EXP5x |EXP5x |EXP5x |EXP5x |
| 6.x    2)|EXP6x |EXP6x |EXP6x |EXP6x |EXP6x |EXP6x |EXP6x |
| 7.x    3)|EXP7x |EXP7x |EXP7x |EXP7x |EXP7x |EXP7x |EXP7x |

 +----------+------+------+------+------+------+------+------+

| 8.0.3    |EXP803|EXP803|EXP803|EXP803|EXP803|EXP803|EXP803|
| 8.0.4    |EXP803|EXP804|EXP804|EXP804|EXP804|EXP804|EXP804|
| 8.0.5    |EXP803|EXP804|EXP805|EXP805|EXP805|EXP805|EXP805|
| 8.0.6    |EXP803|EXP804|EXP805|EXP806|EXP806|EXP806|EXP806|

 +----------+------+------+------+------+------+------+------+

| 8.1.5    |EXP803|EXP804|EXP805|EXP806|EXP815|EXP815|EXP815|
| 8.1.6    |EXP803|EXP804|EXP805|EXP806|EXP815|EXP816|EXP816|
| 8.1.7    |EXP803|EXP804|EXP805|EXP806|EXP815|EXP816|EXP817|

+----------+------+------+------+------+------+------+------+

 Remarks:

1. IMPORT can read export dump files created by EXPORT release 5.1.22 and higher (up to same version).
2. An Oracle5 or Oracle6 export dump and an Oracle8 or Oracle8i IMPORT: see the Oracle Utilities Manual, Chapter 2 "Import" for special considerations to keep in mind.
3. An Oracle7 export dump and an Oracle8 or Oracle8i IMPORT: constraints on the DATE columns become invalid when TO_DATE function has not been used in the constraint (this was not required in earlier Oracle versions). ...

ciao
Andreas

-- 
Andreas Necker

ISB AG              Tel: +49 (0)721/82800-0
Karlstrasse 52-54   Fax: +49 (0)721/82800-82
76133 Karlsruhe     mailto:Andreas.Necker_at_isb-ag.de
Germany             http://www.isb-ag.de

Received on Fri Apr 27 2001 - 08:18:35 CDT