Oracle materialized views workflow [message #670693] |
Fri, 20 July 2018 02:17 |
|
camillelola
Messages: 1 Registered: November 2017
|
Junior Member |
|
|
I am new to Oracle. I wanted to know the solution for below-posted questions based on the details provided.
Questions:
1. What most likely happened? 2. How would you go about figuring out why it happened?
Details: The materialized view named SOMESCHEMA.SOMETABLE is present in an Oracle database. It replicates rows from another Oracle database. While the materialized view has tens of millions of rows in it, it typically does an incremental refresh and the refresh completes in less than a minute. One morning sessions performing writes on your database are failing with many "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS'".
When I run the following query: SELECT owner, mview_name, master_link, refresh_method, fast_refreshable, last_refresh_type FROM dba_mviews WHERE owner = 'SOMESCHEMA' AND mview_name = 'SOMETABLE'
I got the following output:
SOMESCHEMA, SOMETABLE, @"SOME_REMOTE_DB.EXAMPLE.COM", COMPLETE, DIRLOAD_DML, COMPLETE
Thanks & Regards
Camillelola
|
|
|