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
chintu00
Messages: 91
Registered: February 2007
Location: NJ, US
Member
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.

Report message to a moderator

Re: Materialized View [message #351649 is a reply to message #351638] Wed, 01 October 2008 23:27 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Question

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).

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 14 16:14:08 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.