Home » SQL & PL/SQL » SQL & PL/SQL » parameter for creating materialized view (Oracle 10.2.0.1.0 ,unix)
parameter for creating materialized view [message #402450] Sun, 10 May 2009 11:09 Go to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member


Hi all,

Can somebody let me know the initialization parameter we set in spfile for creating materialized view.


Mohan raj
Re: parameter for creating materialized view [message #402451 is a reply to message #402450] Sun, 10 May 2009 11:15 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
There is no such parameter.


You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Re: parameter for creating materialized view [message #402452 is a reply to message #402450] Sun, 10 May 2009 11:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I assume you are talking about materialized view with query rewrite.
If so,
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_6002.htm#i2162987
http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/qrbasic.htm#i1006201

Re: parameter for creating materialized view [message #402453 is a reply to message #402451] Sun, 10 May 2009 11:25 Go to previous message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member


Thanks for your quick response.

As this is my first post,i was not aware of the forum guidelines.
Will follow it from next time. Smile
Previous Topic: Outer join on a decode value
Next Topic: Run query based on parameter
Goto Forum:
  


Current Time: Wed Dec 07 08:57:18 CST 2016

Total time taken to generate the page: 0.09588 seconds