Updating a View

45 pts.
Tags:
Data management and storage
Database
SQL
Updates
Views
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

 

Answer Wiki

Thanks. We'll let you know when a new response is added.

A true “view” automatically updates when the underlying data is updated. Also, in SQL Server an “indexed view” also refreshes automatically.

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…

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Meandyou
    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.
    5,220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following