Re: Copying LONG RAW into BLOB fileds

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 14 Feb 2005 05:54:57 GMT
Message-ID: <pan.2005.02.14.05.54.55.151381@sbcglobal.net>

On Fri, 11 Feb 2005 16:01:55 +0100, Ciccio wrote:

>
> What can I do to overcome this problem????

Export from 8i, import into 9i and do something like:

ALTER TABLE [<schema>.]<table_name>

MODIFY ( <long_column_name> { CLOB | BLOB | NCLOB }

Other then that, read Oracle9i Application Developer's Guide - Large Objects (LOBs)
Miogration is described in the 1st chapter.

--
Bug, noun: Son of a glitch

Received on Sun Feb 13 2005 - 23:54:57 CST