Home » SQL & PL/SQL » SQL & PL/SQL » Materialized View (Oracle 9i)
Materialized View [message #351638] Wed, 01 October 2008 17:03 Go to next message
Messages: 91
Registered: February 2007
Location: NJ, US
I have following scenario

Schema A Schema B
table tab_a table tab_b
Materialized View MV_b(based on tab_a and tab_b )

I submit a SQL in Schema A which uses tab_a and may or may not use other tables/views from the same or other schemas
Will my SQL try to use MV_b in schema B. I have query_rewrite_enabled set in both schemas.
If it will and my MV is invalid when the user submitting the SQL will the process fail trying to do a DDL(compile) because this user does not have a DDL across schema.
Re: Materialized View [message #351649 is a reply to message #351638] Wed, 01 October 2008 23:27 Go to previous message
Michel Cadot
Messages: 65084
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator


Use SQL*PLus and copy and paste an example of what you mean.
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 (See SQL Formatter).
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Previous Topic: help with COUNT function
Next Topic: how to I make relationships between tables in oracle
Goto Forum:

Current Time: Fri Jul 21 16:32:07 CDT 2017

Total time taken to generate the page: 0.24472 seconds