Tagged Questions
-1
votes
1answer
776 views
Materialized views master table
New to this topic - in my current environment we are not doing any replication but we use materialized views frequently in order to achieve performance gains on complex views that are in turn used by ...
2
votes
2answers
691 views
Materialized views use older dbms_job instead of scheduler?
Very new to this topic - using 11g.
When I create a materialized view, a matching job (not a scheduler job) is created. But it's my understanding that dbms_job is being replaced by dbms_scheduler.
...
5
votes
1answer
3k views
Why in Oracle 11gR2 I can't drop the materialized view with the same user that created it?
I created a materialized view with the DI_TEST_AL user, let's name it MY_MVIEW. It appears in the USER_OBJECTS table as MATERIALIZED VIEW, I try to drop it, I get a success message, but the object is ...
7
votes
2answers
1k views
Limit redo for materialized view complete refresh or manual equivalent
A materialized view(MV) log can be used to allow a MV to do a fast refresh which only modifies the data that has changed. However, various conditions prevent the MV from using the log and therefore ...
