Home » Server Options » Text & interMedia » Why index not create??
Why index not create?? [message #308888] Tue, 25 March 2008 18:21 Go to next message
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??


Re: Why index not create?? [message #308895 is a reply to message #308888] Tue, 25 March 2008 19:02 Go to previous messageGo to next message
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.
Re: Why index not create?? [message #308916 is a reply to message #308888] Tue, 25 March 2008 23:14 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
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."
Re: Why index not create?? [message #308928 is a reply to message #308888] Wed, 26 March 2008 00:05 Go to previous message
Barbara Boehmer
Messages: 9077
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.

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


Current Time: Thu Mar 28 09:57:25 CDT 2024