Re: Oracle 8.1.7 to 8.0.5 Table export problem

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 16 May 2003 00:30:14 +1000
Message-ID: <MkNwa.34951$1s1.506600@newsfeeds.bigpond.com>

"DOKNIK" <dominiqs_at_o2.co.uk> wrote in message news:1052999682.908681_at_ernani.logica.co.uk... All,
I have exported a table in Oracle 8.05 to 817 just to use the TO_CLOB function in Oracle 8.1.7 to convert LONGs in the 805 table to CLOBs (as the to_colb function is not shipped with Oracle 805.) After i had converted the LONG to CLOBs successfully .I am now having problems importing the converted table back to the 805 database(from the 817 databse)
I get the errors below

IMP-00002: failed to open /export/home/oracle/bvshop_large_content1.dmp for read
IMP-00021: operating system error - error code (dec 2, hex 0x2)

---

First, please don't post in HTML. It doesn't work well in an awful lot of news readers out there.

Second, the error appears to be an operating system permissions problem, so check that first (chmod 777 springs to mind)>

Third, make sure you do the export using the 8.0 version of exp. That is, from the 8.0 ORACLE_HOME/bin directory, issue the exp user/password_at_8.1.7 command, so that you use the older version of the executable against the higher version of the database, connecting via a perfectly normal tnsnames alias.

Regards

---

I have troied metalink but no joy .
Is ther a better way of doing this or can anyone suggest a solution round this.
My aim is to import the converted table from the 817 database to 805.

Any help would be greatly appreciated.Thanks Received on Thu May 15 2003 - 09:30:14 CDT