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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle 8i Materialised Views

Status
Not open for further replies.
sethu

sethu

Programmer
Apr 15, 2000
29
US
Hi,
I have many objects in my database in INVALID status and I recompiled them. Is there any way to recompile materialised views which has an object type as UNDEFINED?

--Sethu
 
Sort by date Sort by votes
if you try and select from it it should recompile it if need be I think.
 
Upvote 0 Downvote
Hi,

I got the answer.

ALTER MATERIALIZED VIEW <<view_name>> compile;

--Sethu
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rk68
  • Question
Data encryption in Oracle 19c
Replies
0
Views
126
rk68
rk68
J
  • Locked
  • Question
Oracle Simphony - Adding tip out percentages to Employee Tip Report 1
Replies
0
Views
152
jj10438
J
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
289
TheLazyPig
TheLazyPig
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
339
Andrzejek
Andrzejek
gc6294
  • Locked
  • Question
Search for a character in Oracle SQL statement 1
Replies
3
Views
258
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top