Re: Import 8.0 dmp file to 7.2?

You'll need to run catexp7.sql on the Oracle 8 database, run exp72 against the Oracle 8 database run imp72 against the Oracle 7.2 database. Please note 7.2 is way out of support.

Hth,

Sybrand Bakker, Oracle DBA

Karen G <x_at_yz.com> wrote in message
news:MPG.13499ff79ba7df05989682_at_news.newsguy.com...
> Hi all,
> I know you cannot import a version 8.0 dmp file into a 7.2 database...
> but I had another idea to throuw out there...
>
> Import this into an 8.0 database and then make a sqlnet alias from the
> 7.2 machine to that 8.0 machine... then perhaps something like:
>
> imp73 user/pass_at_DB_ALIAS fromuser=whatever touser=whatever
> file=C:\the_dump.dmp full=y commit=y ignore=y
>
> This is trying to run imp73 on an alias connection. valid?
>
> After all this thought I'm anxious for the inevitable easy solution.
>
> Thanks in advance,
> Karen
>
Received on Mon Mar 27 2000 - 23:53:13 CST