OraFAQ Forum: Text & interMedia » Why index not create??

Home » Server Options » Text & interMedia » Why index not create??

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

Why index not create?? [message #308888]

Tue, 25 March 2008 18:21

virgos
Messages: 10
Registered: March 2008

Junior Member

Hi.

I do it like show in Oracle� Text Reference:

#!/usr/local/bin/perl

open(IN, $ARGV[0]);
open(OUT, ">".$ARGV[1]);

while (<IN>)
{
tr/a-z/A-Z/;
print OUT;
}

close (IN);
close (OUT);

Assuming that this file is named upcase.pl, create the filter preference as follows:

begin
ctx_ddl.create_preference
(
preference_name => 'USER_FILTER_PREF',
object_name => 'USER_FILTER'
);
ctx_ddl.set_attribute
('USER_FILTER_PREF','COMMAND','upcase.pl');
end;

Create the index in SQL*Plus as follows:

create index user_filter_idx on user_filter ( docs )
indextype is ctxsys.context
parameters ('FILTER USER_FILTER_PREF');

But index is not create. Exactly creating endless Sad

The executable file exist in the %ORACLE_HOME%/bin directory.

What is in problem??

Report message to a moderator

Re: Why index not create?? [message #308895 is a reply to message #308888]

Tue, 25 March 2008 19:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>What is in problem??
how many concurrent sessions are trying to do this operation?

if you can do so, bounce the DB & try it again.

Report message to a moderator

Re: Why index not create?? [message #308916 is a reply to message #308888]

Tue, 25 March 2008 23:14

Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA

Senior Member

What Oracle version and operating system are you using? If using Oracle 11g on Windows, according to the documentation:

"On Windows systems, the executable that you specify for the USER_FILTER command attribute must now exist in the %ORACLE_HOME%/ctx/bin directory instead of %ORACLE_HOME%/bin."

Report message to a moderator

Re: Why index not create?? [message #308928 is a reply to message #308888]

Wed, 26 March 2008 00:05

Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA

Senior Member

I ran a test on 11g with only one row in the table and only one session and the index creation hung and I had to kill the session. You might contact Oracle support and see if this is a bug.

Report message to a moderator

Previous Topic:	How download files?? -- file_datastore
Next Topic:	Help in building a Ultra Search Query using Java API

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 12 18:45:38 CDT 2022