Path: text.usenetserver.com!out01a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news3.google.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Marten Lehmann <lehmannmapson@cnm.de>
Newsgroups: comp.databases.oracle.misc
Subject: How to store emails with fulltext index
Date: Tue, 27 Nov 2007 20:11:50 +0100
Lines: 15
Message-ID: <5r38jfF1284lmU1@mid.individual.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: individual.net 2fEoAknrHTr15PMJvjwAPA39Nzf/r7nESh0V/tqpbZD/GlOUM=
Cancel-Lock: sha1:Y0AvuTOfAupzp9NuCHu7CfEafSw=
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
Xref: usenetserver.com comp.databases.oracle.misc:250825
X-Received-Date: Tue, 27 Nov 2007 14:13:52 EST (text.usenetserver.com)

Hello,

we are planning to move our mails from local clients (like Thunderbird) 
into the database.

We experienced long search times with the local clients doing fulltext 
search and I guess this would be same if we store the messages as simple 
varchar() records.

Does oracle come with a special email record type that includes 
attachments and fulltext index? How would you recommend to store our 
mails into the database?

Regards
Marten