Re: Import 11g dump in 9i


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
|
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 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@xxxxxx> wrote in message
news:f65b7dea-a389-4bac-a89f-bd96a8a8286a@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: About MS-Access RDBMS
    ... ie you shouldn't be able to say 'fails rule 2 because it ... > database not by applications' own exception processing features. ... > 8) Physical independence rule: ... > data manipulation, integrity rules, authorisation etc. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: About MS-Access RDBMS
    ... Since Access fails rule 1, ... database not by applications' own exception processing features. ... Physical independence rule: applications and interactive operations ... Access can define unique key and foreign key integrity rules, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: CeDeleteRecord Anomalies
    ... > I am trying to use the CeDeleteRecord function on CE4.2. ... > this function fails (repeatable depending on the database I'm using). ... Does your database contain Text as well? ...
    (microsoft.public.windowsce.embedded.vc)
  • Re: [Info-ingres] Replicator and E_US0845
    ... > Having added the replicator catalogs and support objects to a database ... > An attempt to modify or optimize an archive table fails with: ... > Note that I am connecting as the owner of this table. ... > While its probably not a good idea to modify or optimize these tables, ...
    (comp.databases.ingres)
  • Re: Unable to select records correctly in a Continuous Form
    ... if it fails even when HasModule is No, ... > Well, I've removed the code and compacted/repaired the database, have ... > Even without any code behind the form, the continuous form is still not ...
    (microsoft.public.access.forms)