Re: saving emails in an Oracle table

From: Shakespeare <>
Date: Sat, 30 Jan 2010 20:36:55 +0100
Message-ID: <4b648a57$0$22913$>

Op 30-1-2010 19:10, Frank van Bortel schreef:
> Shakespeare wrote:
>> Op 30-1-2010 10:58, Frank van Bortel schreef:
>>> Wallyraju wrote:
>>>> Oracle 11g R1
>>>> RHEL (not sure of version)
>>>> We are in the process of designing a table(s) in Oracle to store all
>>>> the information pertaining to saving everything related to an email
>>>> being sent out.
>>> Why don't you take a look at the definition of MIME?
>>> looks like a valid starting point.
>>> Basically, email is text, so a single CLOB should do it (yes; Clob, not
>>> Blob - just take a look at a base64 coded email)
>>> Apart from that - how do you get your mail IN the database? I know
>>> about emails: how I can SEND FROM, but I sure would like to
>>> RECEIVE INTO the database.
>> ORACLE_MAIL can run as a mail server. Don't know if it is still there
>> as a stand alone database feature. That's why your client uses
>> Collaboration Suite...
>> Shakespeare
> That's why I said "database"... Not some overpriced Oracle (or any)
> product. Nowadays the database is used for almost anything, so
> why not mail receiver? It's a web browser, an email server, an
> application server (HTTP as well as java), an eh... what else?
> Oh yeah - right. You might store data, too. In XML format...

IIRC, oracle mail was just a set of database packages....

Shakespeare Received on Sat Jan 30 2010 - 13:36:55 CST

Original text of this message