Re: Question on conversion LONG RAW to BLOB

From: Dmitry <support_at_ispirer.com>
Date: Mon, 12 Mar 2001 14:10:29 +0200
Message-ID: <98ieb0$23kld$1@ID-75577.news.dfncis.de>

Hi,

What kind of structure convertion in addition to LONG RAW->BLOB do you need to perform?
Could you provide an example?

Best regards, Dmitry.

--
www.ispirer.com - Database migration tools and services for Oracle and IBM
DB2.


"Pascale Panter" <"pascale.panter"@pwgsc.gc.ca;pascale.panter_at_sympatico.ca>
wrote in message news:lrUq6.361399$Pm2.5427787_at_news20.bellglobal.com...


> I have to import data from an Oracle8 database to another Oracle8

> database:

> - not same structure

> - LONG RAW field in one table from the ols database will become a BLOB

> in the new database.

>

> SELECT ... INSERT statement doesn't work. Export/Import using SQL*Loader

> is not feasible because of the change of the database structure.

>

> Can somebody help me on what to do to achieve the conversion (PL/SQL

> program?) ?

>

> Thanks!

>

Received on Mon Mar 12 2001 - 06:10:29 CST