| 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 
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  |
anacedent
Messages: 5027
Registered: July 2005
Location: surf meets turf in 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 #308928 is a reply to message #308888 ] |
Wed, 26 March 2008 00:05 |
 |
Barbara Boehmer
Messages: 3940
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.
|
|
|
]
Members
Search
Help
Register
Login
Home
