Import 11g dump in 9i

#1

Hi list,

we have some 11g and 9i servers and I want to transfer data from an
11g to a 9i one.

Using the exp from 11g naturally fails, because the imp of 9i can't
read the dmp format. Using the imp utility from 9i also fails because
I get a segmentation fault (no message on the command line, but a
Windows window telling me that exp.exe encountered an error.

Using the imp utility from 11g on the 9i also fails.

Does anyone has any idea?

Kind regards,
Christoph

#2

Summary Export/Import compatibility:

1. Export the data with the Export utility of the lowest database version
involved.

2. Import the data with the Import utility of the target database.

Matrix 2: Which Export client to use when importing into an Oracle8i
or a higher database release
(always use the Import client of the target database):

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

Quote:

EXPORT | IMPORT into:

from +--------+--------+--------+--------+--------+--------+--------+
\/ | 8.1.x | 8.1.7 | 9.0.1 | 9.2.0 | 10.1.0 | 10.2.0 | 11.1.0

+-----------+--------+--------+--------+--------+--------+--------+--------+
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 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804

8.0.5 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805

8.0.6 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806

+-----------+--------+--------+--------+--------+--------+--------+--------+
8.1.5 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815

8.1.6 | EXP81x | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816

8.1.7 | EXP81x | EXP817 | EXP817 | EXP817 | EXP817 | EXP817 | EXP817

+-----------+--------+--------+--------+--------+--------+--------+--------+
9.0.1 | EXP81x | EXP817 | EXP901 | EXP901 | EXP901 | EXP901 | EXP901

9.2.0 | N/S | EXP817 | EXP901 | EXP920 | EXP920 | EXP920 | EXP920

+-----------+--------+--------+--------+--------+--------+--------+--------+
10.1.0 4)| N/S | EXP817 | EXP901 | EXP920 | 4)

10.2.0 4)| Not Supported | EXP920 | 4)

+-----------+--------+--------+--------+--------+--------+--------+--------+
11.1.0 4)| Not Supported | EXP920 | 4)

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

"Christoph Schwerdtfeger" <cstealth (AT) gmx (DOT) de> wrote

Quote:

Hi list,

we have some 11g and 9i servers and I want to transfer data from an
11g to a 9i one.

Using the exp from 11g naturally fails, because the imp of 9i can't
read the dmp format. Using the imp utility from 9i also fails because
I get a segmentation fault (no message on the command line, but a
Windows window telling me that exp.exe encountered an error.

Using the imp utility from 11g on the 9i also fails.

Does anyone has any idea?

Kind regards,
Christoph

#3

Summary Export/Import compatibility:

1. Export the data with the Export utility of the lowest database version
involved.

2. Import the data with the Import utility of the target database.

Matrix 2: Which Export client to use when importing into an Oracle8i
or a higher database release
(always use the Import client of the target database):

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

Quote:

EXPORT | IMPORT into:

from +--------+--------+--------+--------+--------+--------+--------+
\/ | 8.1.x | 8.1.7 | 9.0.1 | 9.2.0 | 10.1.0 | 10.2.0 | 11.1.0

+-----------+--------+--------+--------+--------+--------+--------+--------+
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 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804

8.0.5 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805

8.0.6 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806

+-----------+--------+--------+--------+--------+--------+--------+--------+
8.1.5 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815

8.1.6 | EXP81x | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816

8.1.7 | EXP81x | EXP817 | EXP817 | EXP817 | EXP817 | EXP817 | EXP817

+-----------+--------+--------+--------+--------+--------+--------+--------+
9.0.1 | EXP81x | EXP817 | EXP901 | EXP901 | EXP901 | EXP901 | EXP901

9.2.0 | N/S | EXP817 | EXP901 | EXP920 | EXP920 | EXP920 | EXP920

+-----------+--------+--------+--------+--------+--------+--------+--------+
10.1.0 4)| N/S | EXP817 | EXP901 | EXP920 | 4)

10.2.0 4)| Not Supported | EXP920 | 4)

+-----------+--------+--------+--------+--------+--------+--------+--------+
11.1.0 4)| Not Supported | EXP920 | 4)

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

"Christoph Schwerdtfeger" <cstealth (AT) gmx (DOT) de> wrote

Quote:

Hi list,

we have some 11g and 9i servers and I want to transfer data from an
11g to a 9i one.

Using the exp from 11g naturally fails, because the imp of 9i can't
read the dmp format. Using the imp utility from 9i also fails because
I get a segmentation fault (no message on the command line, but a
Windows window telling me that exp.exe encountered an error.

Using the imp utility from 11g on the 9i also fails.

Does anyone has any idea?

Kind regards,
Christoph

#4

Summary Export/Import compatibility:

1. Export the data with the Export utility of the lowest database version
involved.

2. Import the data with the Import utility of the target database.

Matrix 2: Which Export client to use when importing into an Oracle8i
or a higher database release
(always use the Import client of the target database):

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

Quote:

EXPORT | IMPORT into:

from +--------+--------+--------+--------+--------+--------+--------+
\/ | 8.1.x | 8.1.7 | 9.0.1 | 9.2.0 | 10.1.0 | 10.2.0 | 11.1.0

+-----------+--------+--------+--------+--------+--------+--------+--------+
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 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804

8.0.5 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805

8.0.6 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806

+-----------+--------+--------+--------+--------+--------+--------+--------+
8.1.5 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815

8.1.6 | EXP81x | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816

8.1.7 | EXP81x | EXP817 | EXP817 | EXP817 | EXP817 | EXP817 | EXP817

+-----------+--------+--------+--------+--------+--------+--------+--------+
9.0.1 | EXP81x | EXP817 | EXP901 | EXP901 | EXP901 | EXP901 | EXP901

9.2.0 | N/S | EXP817 | EXP901 | EXP920 | EXP920 | EXP920 | EXP920

+-----------+--------+--------+--------+--------+--------+--------+--------+
10.1.0 4)| N/S | EXP817 | EXP901 | EXP920 | 4)

10.2.0 4)| Not Supported | EXP920 | 4)

+-----------+--------+--------+--------+--------+--------+--------+--------+
11.1.0 4)| Not Supported | EXP920 | 4)

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

"Christoph Schwerdtfeger" <cstealth (AT) gmx (DOT) de> wrote

Quote:

Hi list,

we have some 11g and 9i servers and I want to transfer data from an
11g to a 9i one.

Using the exp from 11g naturally fails, because the imp of 9i can't
read the dmp format. Using the imp utility from 9i also fails because
I get a segmentation fault (no message on the command line, but a
Windows window telling me that exp.exe encountered an error.

Using the imp utility from 11g on the 9i also fails.

Does anyone has any idea?

Kind regards,
Christoph

#5

Summary Export/Import compatibility:

1. Export the data with the Export utility of the lowest database version
involved.

2. Import the data with the Import utility of the target database.

Matrix 2: Which Export client to use when importing into an Oracle8i
or a higher database release
(always use the Import client of the target database):

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

Quote:

EXPORT | IMPORT into:

from +--------+--------+--------+--------+--------+--------+--------+
\/ | 8.1.x | 8.1.7 | 9.0.1 | 9.2.0 | 10.1.0 | 10.2.0 | 11.1.0

+-----------+--------+--------+--------+--------+--------+--------+--------+
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 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804

8.0.5 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805

8.0.6 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806

+-----------+--------+--------+--------+--------+--------+--------+--------+
8.1.5 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815

8.1.6 | EXP81x | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816

8.1.7 | EXP81x | EXP817 | EXP817 | EXP817 | EXP817 | EXP817 | EXP817

+-----------+--------+--------+--------+--------+--------+--------+--------+
9.0.1 | EXP81x | EXP817 | EXP901 | EXP901 | EXP901 | EXP901 | EXP901

9.2.0 | N/S | EXP817 | EXP901 | EXP920 | EXP920 | EXP920 | EXP920

+-----------+--------+--------+--------+--------+--------+--------+--------+
10.1.0 4)| N/S | EXP817 | EXP901 | EXP920 | 4)

10.2.0 4)| Not Supported | EXP920 | 4)

+-----------+--------+--------+--------+--------+--------+--------+--------+
11.1.0 4)| Not Supported | EXP920 | 4)

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

"Christoph Schwerdtfeger" <cstealth (AT) gmx (DOT) de> wrote

Quote:

Hi list,

we have some 11g and 9i servers and I want to transfer data from an
11g to a 9i one.

Using the exp from 11g naturally fails, because the imp of 9i can't
read the dmp format. Using the imp utility from 9i also fails because
I get a segmentation fault (no message on the command line, but a
Windows window telling me that exp.exe encountered an error.

Using the imp utility from 11g on the 9i also fails.

Does anyone has any idea?

Kind regards,
Christoph

#6

On 20 Mrz., 11:13, "Jack" <n... (AT) INVALIDmail (DOT) com> wrote:

Quote:

Summary Export/Import compatibility:

1. Export the data with the Export utility of the lowest database version
involved.

2. Import the data with the Import utility of the target database.

Matrix 2: Which Export client to use when importing into an Oracle8i
or a higher database release
(always use the Import client of the target database):

+-----------+--------------------------------------------------------------+
| EXPORT | IMPORT into:
|
| from +--------+--------+--------+--------+--------+--------+--------+
| \/ | 8.1.x | 8.1.7 | 9.0.1 | 9.2.0 | 10.1.0 | 10.2.0 | 11.1.0
|
+-----------+--------+--------+--------+--------+--------+--------+--------+
[...]
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 11.1.0 4)| Not Supported | EXP920 | 4)
|
+-----------+--------+--------+--------+--------+--------+--------+--------+

According to this matrix 9.2 should work with 11g.

As you can see on the screenshot[1] I'm using version 9.2.0.1.0 to
connect to the 11g database - without success.

The screenshot is in German, but I guess you can understand most
parts. If not, I'll translate it.

Regards,
Christoph

PS.: Jack, sorry for directly mailing my first answer to you.

[1] http://img139.imageshack.us/my.php?i...e11gexpih3.jpg

#7

On 20 Mrz., 11:13, "Jack" <n... (AT) INVALIDmail (DOT) com> wrote:

Quote:

Summary Export/Import compatibility:

1. Export the data with the Export utility of the lowest database version
involved.

2. Import the data with the Import utility of the target database.

Matrix 2: Which Export client to use when importing into an Oracle8i
or a higher database release
(always use the Import client of the target database):

+-----------+--------------------------------------------------------------+
| EXPORT | IMPORT into:
|
| from +--------+--------+--------+--------+--------+--------+--------+
| \/ | 8.1.x | 8.1.7 | 9.0.1 | 9.2.0 | 10.1.0 | 10.2.0 | 11.1.0
|
+-----------+--------+--------+--------+--------+--------+--------+--------+
[...]
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 11.1.0 4)| Not Supported | EXP920 | 4)
|
+-----------+--------+--------+--------+--------+--------+--------+--------+

According to this matrix 9.2 should work with 11g.

As you can see on the screenshot[1] I'm using version 9.2.0.1.0 to
connect to the 11g database - without success.

The screenshot is in German, but I guess you can understand most
parts. If not, I'll translate it.

Regards,
Christoph

PS.: Jack, sorry for directly mailing my first answer to you.

[1] http://img139.imageshack.us/my.php?i...e11gexpih3.jpg

#8

On 20 Mrz., 11:13, "Jack" <n... (AT) INVALIDmail (DOT) com> wrote:

Quote:

Summary Export/Import compatibility:

1. Export the data with the Export utility of the lowest database version
involved.

2. Import the data with the Import utility of the target database.

Matrix 2: Which Export client to use when importing into an Oracle8i
or a higher database release
(always use the Import client of the target database):

+-----------+--------------------------------------------------------------+
| EXPORT | IMPORT into:
|
| from +--------+--------+--------+--------+--------+--------+--------+
| \/ | 8.1.x | 8.1.7 | 9.0.1 | 9.2.0 | 10.1.0 | 10.2.0 | 11.1.0
|
+-----------+--------+--------+--------+--------+--------+--------+--------+
[...]
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 11.1.0 4)| Not Supported | EXP920 | 4)
|
+-----------+--------+--------+--------+--------+--------+--------+--------+

According to this matrix 9.2 should work with 11g.

As you can see on the screenshot[1] I'm using version 9.2.0.1.0 to
connect to the 11g database - without success.

The screenshot is in German, but I guess you can understand most
parts. If not, I'll translate it.

Regards,
Christoph

PS.: Jack, sorry for directly mailing my first answer to you.

[1] http://img139.imageshack.us/my.php?i...e11gexpih3.jpg

#9

On 20 Mrz., 11:13, "Jack" <n... (AT) INVALIDmail (DOT) com> wrote:

Quote:

Summary Export/Import compatibility:

1. Export the data with the Export utility of the lowest database version
involved.

2. Import the data with the Import utility of the target database.

Matrix 2: Which Export client to use when importing into an Oracle8i
or a higher database release
(always use the Import client of the target database):

+-----------+--------------------------------------------------------------+
| EXPORT | IMPORT into:
|
| from +--------+--------+--------+--------+--------+--------+--------+
| \/ | 8.1.x | 8.1.7 | 9.0.1 | 9.2.0 | 10.1.0 | 10.2.0 | 11.1.0
|
+-----------+--------+--------+--------+--------+--------+--------+--------+
[...]
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 11.1.0 4)| Not Supported | EXP920 | 4)
|
+-----------+--------+--------+--------+--------+--------+--------+--------+

According to this matrix 9.2 should work with 11g.

As you can see on the screenshot[1] I'm using version 9.2.0.1.0 to
connect to the 11g database - without success.

The screenshot is in German, but I guess you can understand most
parts. If not, I'll translate it.

Regards,
Christoph

PS.: Jack, sorry for directly mailing my first answer to you.

[1] http://img139.imageshack.us/my.php?i...e11gexpih3.jpg

#10

On Mar 20, 10:06*am, Christoph Schwerdtfeger <cstea... (AT) gmx (DOT) de> wrote:

Quote:

On 20 Mrz., 11:13, "Jack" <n... (AT) INVALIDmail (DOT) com> wrote:

Summary Export/Import compatibility:

1. Export the data with the Export utility of the lowest database version
involved.

2. Import the data with the Import utility of the target database.

Matrix 2: Which Export client to use when importing into an Oracle8i
* * * * * *or a higher database release
* * * * * (always use the Import client of the target database):

+-----------+--------------------------------------------------------------*+
| *EXPORT * | * * * * * * * * * * * * *IMPORT into:
|
| * from * *+--------+--------+--------+--------+--------+--------+--------+
| * *\/ * * | *8.1.x | *8.1.7 | * 9.0.1 | *9.2.0 | 10.1.0 | 10.2.0 | 11.1.0
|
+-----------+--------+--------+--------+--------+--------+--------+--------*+
[...]
+-----------+--------+--------+--------+--------+--------+--------+--------*+
| 11.1.0 *4)| * * *Not Supported * * * | EXP920 | * * * * * * *4)
|
+-----------+--------+--------+--------+--------+--------+--------+--------*+

According to this matrix 9.2 should work with 11g.

As you can see on the screenshot[1] I'm using version 9.2.0.1.0 to
connect to the 11g database - without success.

The screenshot is in German, but I guess you can understand most
parts. If not, I'll translate it.

Regards,
Christoph

PS.: Jack, sorry for directly mailing my first answer to you.

[1]http://img139.imageshack.us/my.php?image=oracle11gexpih3.jpg- Hide quoted text -

- Show quoted text -

You haven't patched your 9.2 database to 9.2.0.8? Or haven't you
applied the 9.2.0.8 patchset to the client installation? It might be
worth the effort to do so.

David Fitzjarrell