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

Hi Cheers

We've had this problem!

First you need to run CATEXP7.SQL on the 805 database, using SQL*Plus connected as SYSTEM (or SYS - I can't remember which). This will create the necessary views / tables / synonyms to allow an Oracle7 export.

Then you need to run EXP73 from a machine with Oracle7 on it, pointing at the Oracle805 database.

Tim
==

"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 Thu Dec 07 2000 - 08:54:51 CST