Home » SQL & PL/SQL » SQL & PL/SQL » nested materialized views (oracle 10g)
icon9.gif  nested materialized views [message #426593] Fri, 16 October 2009 15:43 Go to next message
Messages: 1
Registered: October 2009
Junior Member
Hope someone can help me

I have created 2 materialized views M1 and M2..M1 and M2 have count operator ....The refresh opiton is FORCE and I have created Materialized View Logs on both of them.

Now I try to create a 3rd MV using columns in both M1 and M2 , But I get the error "Sql query executed withour errors but Cannot find Relation M1 and M2

Can anyone shed some light on this

thanks in advance
Re: nested materialized views [message #426613 is a reply to message #426593] Sat, 17 October 2009 01:20 Go to previous message
Michel Cadot
Messages: 65137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This does not seem to be an Oracle error.
Use SQL*Plus and copy and paste your session.

Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags.
Use the "Preview Message" button to verify.
Also always post your Oracle version with 4 decimals.


[Updated on: Sat, 17 October 2009 01:21]

Report message to a moderator

Previous Topic: Pls help me
Next Topic: join
Goto Forum:

Current Time: Thu Aug 17 04:54:31 CDT 2017

Total time taken to generate the page: 0.15969 seconds