Home » SQL & PL/SQL » SQL & PL/SQL » Oracle materialized views workflow
Oracle materialized views workflow [message #670693] Fri, 20 July 2018 02:17 Go to previous message
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
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: ORA-04091: table Table_Name is mutating, trigger/function may not see it
Next Topic: PL/SQL: ORA-04053: error occurred when validating remote object
Goto Forum:
  


Current Time: Thu Mar 28 06:53:11 CDT 2024