"Tim Shute" <tshute_at_nisoft.com> wrote in message
news:31E25B03208FD411B0E5006097A4426B122E30_at_ORION...
> 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.
>
Thank You.
> 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 - 12:55:24 CST
