Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Export/Import Question (from 8.0.5 to 7.3.4)
Hello there,
Background:
I have an Oracle 8.0.5 database running on a Linux machine. This operating
system will not be supported in the future because I quit my job. This is
the reason to place the data that is currently in this database on a
platform that will be supported by our IT-department (Windows NT). I have a
Windows NT server running Oracle 7.3.4 (upgrade to higher Oracle version not
an issue yet).
Actions taken:
I created a database with the correct table spaces on the NT system and
created a user ARADMIN with the correct privileges on the new database. I
then performed an export of the user ARADMIN on the Linux system (version
8.0.5).
Result:
When I tried to import the data using the import utility on the NT system
(version 7.3.4), it found the export file of invalid format. Next I tried to
use the import tool on the Linux system to import data in the database on
the NT server. It then complained that it couldn't find the necessary
objects in the catalog to perform this operation. As a last resort I tried
to create a userdump of the ARADMIN user on the database running on the
Linux machine using the export utility on the NT system. This didn't work
either.
Question:
How do I put the data from the Oracle 8.0.5 database in the Oracle 7.3.4
database? The table definitions are compatible (no nested tables, not more
then one clob column in a table).
Cheers Received on Wed Dec 06 2000 - 17:37:05 CST