Re: saving emails in an Oracle table
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 31 Jan 2010 11:13:15 +0100
Message-ID: <dbfa9$4b6557bb$524ba3af$963_at_cache6.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 right; but only outgoing. Never managed incoming mail. And it can only handle outgoing mail when connected to an email relay
Date: Sun, 31 Jan 2010 11:13:15 +0100
Message-ID: <dbfa9$4b6557bb$524ba3af$963_at_cache6.tilbu1.nb.home.nl>
Shakespeare wrote:
> 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?
>>>> 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... >> > > IIRC, oracle mail was just a set of database packages.... > > Shakespeare
That's right; but only outgoing. Never managed incoming mail. And it can only handle outgoing mail when connected to an email relay
-- Regards, Frank van Bortel Topposting in Usenet groups I regard as offensive - I will not replyReceived on Sun Jan 31 2010 - 04:13:15 CST