Re: Export/Import Question (from 8.0.5 to 7.3.4)

You need to run 7.3.4 exp against the 8.0.5 database, there is no other solution.

8.0.5 has been desupported
7.3.4 will be desupported in 24 days time.

Regards,

Sybrand Bakker, Oracle DBA

"cheers" <cheers_at_home.nl> wrote in message news:B4AX5.94445$Ae1.1308240_at_zwoll1.home.nl...
> 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 - 23:38:47 CST