| 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??
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
