DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: complex_view_merging

  1. #1
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455

    complex_view_merging

    I'm working on Oracle 7.3.x

    Can you please tell me if it is possible to set
    complex_view_merging=false

    if yes, then how do I set it at session level?

    Thanks in Advance

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You can do an alter session like:

    1* alter session set COMPLEX_VIEW_MERGING=TRUE
    SQL> /

    Session altered.

    Or you can put it in your init file. The question is does this parameter exist in 7.3.x? If it does you should be able to query it in the v$parameters table, if not you will need to upgrade eventually anyway.

    http://download-west.oracle.com/docs...mops.htm#27665

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