Re: Export/Import from 8.x to 7.x problem

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Mon, 15 Mar 1999 13:13:54 -0800
Message-ID: <36ED7812.743BD469@us.oracle.com>

Jason

To export successfully, the ORACLE_HOME environment variable must point to the correct database. In other words you need to do the export with an Oracle7 ORACLE_HOME. How big is the export? Is it something you can do across the network using your AIX ORACLE_HOME?

HTH. Pete

Jason Ladew wrote:

> Hello,
>
> I am exporting a schema owner user from an Oracle8 DB on a Linus box
> and importing the user to an Oracle7 DB on AIX (7.3.4). On the import
> I get the following errors:
>
> IMP-00010: not a valid export file, header failed verification
> IMP-00021: operating system error - error code (dec 2, hex 0x2)
>
> Does anyone know why? When I export, should I export it using some
> special flag for 8 to 7 conversion? Is there a special EXP or IMP for
> loading ver8.x to ver7.x dumps?
>
> here are the commands I use:
>
> Export cmd line:
> exp user/pw buffer=100000 file=<dump filename> compress=y grant=n
> log=log.log
>
> Import cmd line:
> imp user/pw buffer=200000 file=<filename> grants=n log=log.log
> fromuser=train touser=train3
>
> please reply to devdewboy_at_hotmail.com
>
> Thanks,
>
> jasonl

--

Regards

Pete

---

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)

Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark   2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

---

Received on Mon Mar 15 1999 - 15:13:54 CST