Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 8.1.7 to 8.0.5 Table export problem

Oracle 8.1.7 to 8.0.5 Table export problem

From: DOKNIK <dominiqs_at_o2.co.uk>
Date: Thu, 15 May 2003 13:03:22 +0100
Message-ID: <1052999682.908681@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)

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 - 07:03:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US