-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|