Re: Oracle error IMP 00021

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 1 Oct 2001 18:22:31 +0200
Message-ID: <trh7fs912evof9@news.demon.nl>

"Alter" <alterego_at_cyberspace.org> wrote in message news:26f548ec.0110010802.2abceb6a_at_posting.google.com...
> I'm trying to export data from Oracle 8i in NT to a Oracle 7.3 in HP-UX
> I ran the catexp7.sql file against Oracle 8i and did the export, but when
> i try to import the file in Oracle 7.3 HP-UX Database it doesn't work.
>
> Waiting for help..

You forgot one crucial step:
You need to run the 73 exp against the 8i database, the *very purpose* of running catexp7.sql is to enable exp73 to run against the database. You try to import an Oracle 8 export in an Oracle 7 database. The correct procedure has been posted on many sites and in this newsgroup.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Mon Oct 01 2001 - 11:22:31 CDT