Re: function based indexes

hi Daniel,

thanks a lot for ur help.

Originally posted by Da Morgan
> cheechong wrote:
>
> > hi Daniel,
> > nope. these 2 lines are not found in my .ora file.
> > so these are the 2 lines that are causing the problem?
> > --
> > chee chong
> They are required for the creation of function based indexes.
>
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a9-
> 6540/statements_510a.htm#2071327"]http://download-west.oracle.com/doc-
> s/cd/B10501_01/server.920/a96540/statements_510a.htm#2071327[/url]
>
> To quote:
> To create a function-based index in your own schema on your own table,
> in addition to the prerequisites for creating a conventional
> index, you
> must have the QUERY REWRITE system privilege. To create the index in
> another schema or on another schema's table, you must have the GLOBAL
> QUERY REWRITE privilege. In both cases, the table owner must also have
> the EXECUTE object privilege on the function(s) used in the
> function-based index. In addition, in order for Oracle to use
> function-based indexes in queries, the QUERY_REWRITE_ENABLED parameter
> must be set to TRUE, and the QUERY_REWRITE_INTEGRITY parameter must be
> set to TRUSTED.
>

Daniel Morgan

--
Posted via http://dbforums.com