Re: saving emails in an Oracle table
From: Tim X <timx_at_nospam.dev.null>
Date: Mon, 01 Feb 2010 17:26:46 +1100
Message-ID: <87iqaho4ih.fsf_at_lion.rapttech.com.au>
Shakespeare <whatsin_at_xs4all.nl> writes:
>>>>>> Wallyraju wrote:
>>>>>> 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.
My recollection was that it was just a MUA (Mail user agent). You told it where the server was and it connected via TCP to (usually) port 25 of that server and used the basic SMTP protocol to pass the message to the server which then sent it to wherever. I don't believe there was any MTA (mail transport agent) in the package.
Date: Mon, 01 Feb 2010 17:26:46 +1100
Message-ID: <87iqaho4ih.fsf_at_lion.rapttech.com.au>
Shakespeare <whatsin_at_xs4all.nl> writes:
> Op 31-1-2010 11:13, Frank van Bortel schreef: >> 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 >> > You may be right about that, too long ago... >
My recollection was that it was just a MUA (Mail user agent). You told it where the server was and it connected via TCP to (usually) port 25 of that server and used the basic SMTP protocol to pass the message to the server which then sent it to wherever. I don't believe there was any MTA (mail transport agent) in the package.
Tim
-- tcross (at) rapttech dot com dot auReceived on Mon Feb 01 2010 - 00:26:46 CST