searching email body content with oracle text
Hello all
I'm facing this tricky problem regarding oracle text 10g:
I need to index email outlook messages.
For that I've created a content index like:
execute ctx_ddl.create_preference('filter2mail', 'AUTO_FILTER');
CREATE INDEX idx_email_test ON orcl_txt_user.TEST_EMAIL(EMAIL_FILE_NAME) INDEXTYPE IS ctxsys.context
PARAMETERS ('datastore pref_email_test filter filter2mail storage orcltxt_ppm_mail_storage');
And I find out that I was able to scan the email body but not any attachment !
Then, I used the filter MAIL_FILTER
execute ctx_ddl.create_preference('filter2mail', 'MAIL_FILTER');
with the following filter configuration
I'm facing this tricky problem regarding oracle text 10g:
I need to index email outlook messages.
For that I've created a content index like:
execute ctx_ddl.create_preference('filter2mail', 'AUTO_FILTER');
CREATE INDEX idx_email_test ON orcl_txt_user.TEST_EMAIL(EMAIL_FILE_NAME) INDEXTYPE IS ctxsys.context
PARAMETERS ('datastore pref_email_test filter filter2mail storage orcltxt_ppm_mail_storage');
And I find out that I was able to scan the email body but not any attachment !
Then, I used the filter MAIL_FILTER
execute ctx_ddl.create_preference('filter2mail', 'MAIL_FILTER');
with the following filter configuration
0