long to clob conversion.

From: John Wang <wang_john_at_bah.com>
Date: Mon, 12 Jul 1999 13:36:16 -0400
Message-ID: <7md90r$5jr$1@autumn.news.rcn.net>

Hi, all:

I have a table that has a long data type in 7.3.3 database. Now, I am trying to convert it to a clob datatype in oracle 805. How do I do it? I actually have a 8i database. To_lob function in 8i converted it correctly. But 805 does not have it. If I use exp80 to import 8i dump, i get "unrecognized statement in the export file". If I use exp80 to export the 8i database, I get "invalid column name". Does anyone know how to convert a long to clob?

thanks

jw. Received on Mon Jul 12 1999 - 12:36:16 CDT