Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Materialized view status

Status
Not open for further replies.
Rajesh99

Rajesh99

Programmer
Mar 17, 2003
43
US
Is there a dictionary view that can give me status of refresh of Materialzed view(i.e, success, error code if failed on error etc)?
 
Sort by date Sort by votes
SYS.DBMS_MVIEWS will tell you its last refresh date and refresh type.
 
Upvote 0 Downvote
Is there a view that can give me cause of error why it failed on refresh(SQLERROR)?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Getting PL/SQL: ORA-00942: table or view does not exist
Replies
8
Views
392
tekpr00
tekpr00
AlStl
  • Locked
  • Question
Update via a VIEW or Direct Update
Replies
3
Views
134
Beilstwh
Beilstwh
cmmrfrds
  • Locked
  • Question
Materialized View (Fast Refresh) How to?
Replies
0
Views
94
cmmrfrds
cmmrfrds
NWildblood
  • Locked
  • Question
Detect Rare Changes of Status in Very Large Recordset 2
Replies
8
Views
109
NWildblood
NWildblood
OraclerUser
  • Locked
  • Question
Materialized View: expression not supported for query rewrite error
Replies
2
Views
176
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top