Re: saving emails in an Oracle table
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 30 Jan 2010 19:10:19 +0100
Message-ID: <d1323$4b64760a$524ba3af$26151_at_cache1.tilbu1.nb.home.nl>
Shakespeare wrote:
>> 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?
>> http://en.wikipedia.org/wiki/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.
>>
Date: Sat, 30 Jan 2010 19:10:19 +0100
Message-ID: <d1323$4b64760a$524ba3af$26151_at_cache1.tilbu1.nb.home.nl>
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?
>> http://en.wikipedia.org/wiki/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...
-- Regards, Frank van Bortel Top posting in Usenet groups I regard as offensive - I will not replyReceived on Sat Jan 30 2010 - 12:10:19 CST