Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news.alt.net!news.usenetgateway.com!not-for-mail From: cheechong Newsgroups: comp.databases.oracle.misc Subject: Re: function based indexes Date: Mon, 03 Mar 2003 15:16:35 +0000 Organization: dBforums Lines: 37 Sender: cheechong Message-ID: <2596467.1046704595@dbforums.com> References: <2581376.1046328819@dbforums.com> <3E5E8FD8.AFD59015@exesolutions.com> <2588318.1046449697@dbforums.com> <3E6058FD.58AB005D@exesolutions.com> <2592173.1046533731@dbforums.com> <3E61476A.5CDFEF28@exesolutions.com> User-Agent: dBforums X-Original-NNTP-Posting-Host: dbforums.com X-Original-Trace: 3 Mar 2003 11:25:58 -0500, dbforums.com X-Authenticated-User: paul Xref: newsfeed1.easynews.com comp.databases.oracle.misc:94288 X-Received-Date: Mon, 03 Mar 2003 09:25:54 MST (news.easynews.com) 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