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 SkipVought 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
0
0
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
166
tekpr00
tekpr00
AlStl
  • Locked
  • Question
Update via a VIEW or Direct Update
Replies
3
Views
61
Beilstwh
Beilstwh
cmmrfrds
  • Locked
  • Question
Materialized View (Fast Refresh) How to?
Replies
0
Views
34
cmmrfrds
cmmrfrds
NWildblood
  • Locked
  • Question
Detect Rare Changes of Status in Very Large Recordset 2
Replies
8
Views
32
NWildblood
NWildblood
OraclerUser
  • Locked
  • Question
Materialized View: expression not supported for query rewrite error
Replies
2
Views
44
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top