OraFAQ Forum: Text & interMedia » Oracle text concatenated datastore

Home » Server Options » Text & interMedia » Oracle text concatenated datastore

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle text concatenated datastore [message #293320]

Fri, 11 January 2008 12:19

xokas11
Messages: 28
Registered: January 2008
Location: Guadalajara, Spain

Junior Member

Hi!
Currently I am developing some PL/SQL functions to search my database. The thing is i don´t really know how to create multicolumn indexes on text columns(I want to be able to search forum titles and messages and blog titles and messages).
I found in the oracle site that you can use a concatenated data store(more specifically i found this "http://www.oracle.com/technology/sample_code/products/text/htdocs/concatenated_text_datastore/cdstore_readme.html")
It looks like a very decent solution but we haven´t been able to make it work(My DBA is trying to solve it right now). I don´t know what kind of permission or roles my user should have to be able to use this concatenated data store.
I've searched through this site an I have found this post http://www.orafaq.com/forum/t/41341/0/
It looks promising but if I have followed the steps and I wasn't able to make it work on my database tables.
So what I am looking for is the following:
- What kind of roles/permits should my user(let's call him dummy_user) have?
- In relation to the other post : Which user has to create the data store?

Thanks in advance for your time.
Greetings, Joaquin.

Report message to a moderator

[Message index]

		Oracle text concatenated datastore By: xokas11 on Fri, 11 January 2008 12:19
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Fri, 11 January 2008 19:25
		Re: Oracle text concatenated datastore By: xokas11 on Fri, 11 January 2008 20:16
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Fri, 11 January 2008 20:28
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Fri, 11 January 2008 20:32
		Re: Oracle text concatenated datastore By: xokas11 on Tue, 15 January 2008 11:41
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Tue, 15 January 2008 14:48
		Re: Oracle text concatenated datastore By: xokas11 on Mon, 21 January 2008 12:53
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Mon, 21 January 2008 15:25
		Re: Oracle text concatenated datastore By: xokas11 on Tue, 22 January 2008 12:21
		Re: Oracle text concatenated datastore By: redonisc on Mon, 10 March 2008 16:58
		Re: Oracle text concatenated datastore By: xokas11 on Mon, 10 March 2008 17:13
		Re: Oracle text concatenated datastore By: redonisc on Mon, 10 March 2008 17:28
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Mon, 10 March 2008 17:35
		Re: Oracle text concatenated datastore By: redonisc on Tue, 11 March 2008 10:59
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Tue, 11 March 2008 14:43
		Re: Oracle text concatenated datastore By: rozora on Sun, 03 January 2010 09:16
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Sun, 03 January 2010 16:09
		Re: Oracle text concatenated datastore By: rozora on Sun, 03 January 2010 18:04
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Mon, 04 January 2010 05:15
		Re: Oracle text concatenated datastore By: rozora on Mon, 04 January 2010 06:32
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Mon, 04 January 2010 16:37
		Re: Oracle text concatenated datastore By: rozora on Mon, 04 January 2010 18:10
		Re: Oracle text concatenated datastore By: rozora on Tue, 05 January 2010 03:42
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Tue, 05 January 2010 05:09
		Re: Oracle text concatenated datastore By: rozora on Tue, 05 January 2010 06:06
		Re: Oracle text concatenated datastore By: rozora on Tue, 05 January 2010 09:27
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Tue, 05 January 2010 10:11
		Re: Oracle text concatenated datastore By: rozora on Wed, 13 January 2010 03:06
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Thu, 14 January 2010 15:31
		Re: Oracle text concatenated datastore By: rozora on Wed, 20 January 2010 05:16
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Wed, 20 January 2010 15:17
		Re: Oracle text concatenated datastore By: redonisc on Fri, 14 March 2008 11:11
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Fri, 14 March 2008 14:36
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Fri, 14 March 2008 14:39
		Re: Oracle text concatenated datastore By: redonisc on Fri, 14 March 2008 15:22
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Fri, 14 March 2008 20:45
		Re: Oracle text concatenated datastore By: redonisc on Mon, 17 March 2008 12:51
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Mon, 17 March 2008 14:03
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Mon, 17 March 2008 14:23
		Re: Oracle text concatenated datastore By: redonisc on Mon, 17 March 2008 18:57
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Mon, 17 March 2008 19:18
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Mon, 17 March 2008 22:26
		Re: Oracle text concatenated datastore By: redonisc on Tue, 18 March 2008 18:48
		Re: Oracle text concatenated datastore By: Barbara Boehmer on Tue, 18 March 2008 22:46

Previous Topic:	Highlighting search results with user_datastore context index
Next Topic:	Wildcard Seraches Using CONTAINS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 22:51:03 CDT 2024