QUERY REWRITE,QUERY_REWRITE_ENABLED,QUERY_REWRITE_INTEGRITY!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: QUERY REWRITE,QUERY_REWRITE_ENABLED,QUERY_REWRITE_INTEGRITY!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi!

    Queries:

    1.What is meant by the following:

    a.SQL> GRANT QUERY REWRITE TO SCOTT;
    Grant succeeded.
    b.SQL> ALTER SESSION SET QUERY_REWRITE_ENABLED=TRUE;
    Session altered.
    SQL> ALTER SESSION SET QUERY_REWRITE_INTEGRITY=TRUSTED;
    Session altered.

    Regards,

    Amitstora!

  2. #2
    Those are the priveleges required to create a function based index.

    See http://otn.oracle.com/docs/products/...dexes.htm#2943

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width