Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle 8.1.7 to 8.0.5 Table export problem
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