Meandyou 
1840 pts. | Oct 13 2009 3:44PM GMT
the question says “a view is missing data” - does that mean you want to add one or more columns to the view?
If so, the ALTER VIEW should do it - or DROP VIEW followed by CREATE VIEW.
Q:
Updating a View
I have a view that's missing data and needs to be updated. I'm not sure how to update a view - any help would be greatly appreciated.
The database name is: ABCD_Dbase
The view that needs to be updated is: dbo.vGoLPgcfos
Thanks in advance.
~DJ
The database name is: ABCD_Dbase
The view that needs to be updated is: dbo.vGoLPgcfos
Thanks in advance.
~DJ
ASKED:
Oct 8 2009 8:00 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
If this is an Oracle materialized view, then the view definition can specify the refresh method for automatic refreshing (periodically on a timed basis or whenever an underlying table is changed). You would need to edit the view definition to change this.
If this is an Oracle materialized view with no refresh method specified, you can force a refresh using one of the following Oracle library functions:
DBMS_MVIEW.REFRESH - select one or more materialized views to refresh
DBMS_MVIEW.REFRESH_DEPENDENT - refresh those which depend on a table
DBMS_MVIEW.REFRESH_ALL_MVIEWS - refresh all materialized views
If this is SQL Server, you may want to confirm that this really is a View, and not a real table that someone constructed...
