RE: Data conversion

Yigal,

I seem to remember Notes (via NotesPump) having problems accessing Oracle's BLOB/CLOB. So, you might have problems inserting directly from Notes into Oracle. Maybe other third party tools can handle the migration between the two?

I'm not sure that I can be of much help here. When you say document, I assume what you are referring to what Notes calls a document, very similar to what we might call a row, and, maybe the Notes documents include rich text fields, allowing for the large size (or maybe even attachments)? And I haven't run into an 32K limit with SQL*Loader; but, I've never really tried loading something like that. Most of what I have done has been pretty straightforward with maximum lengths of data files records probably never exceeding 2000 characters or so.

Though I haven't done it, it seems like SQL*Loader can handle loading BLOB/CLOB. I think I saw an example where the raw data contained a reference to a file name. How you could extract the Notes data out into such a format, I don't know. DBMS_LOB might help; but, you would still be faced with how you get the data out of Notes.

Sorry I couldn't be of much help. We are touching on areas where I'm not very skilled. I sent e-mails to a couple of Notes people I know to see if they have any ideas.

Good luck,

Larry G. Elkins
The Elkins Organization Inc.
elkinsl_at_flash.net
214.954.1781

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Yigal Ran Sent: Friday, August 11, 2000 11:56 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Data conversion

Larry,

Thanks for the response, I am planning on transferring documents that are larger than the 32K bytes which is the SQL*Loader limit. I was wondering if Lotus Notes have the ability to insert large data fields into BLOB or CLOB. Received on Mon Aug 14 2000 - 18:39:57 CDT