DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: invalid view

  1. 08-14-2001, 02:27 PM #1
    panjub_raj
    panjub_raj is offline Junior Member
    Join Date
    Mar 2001
    Posts
    78
    What is the syntax that would make an invalid view valid?
    Reply With Quote Reply With Quote
  2. 08-14-2001, 02:29 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    alter view view_name compile;
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 08-14-2001, 04:03 PM #3
    kris109's Avatar
    kris109
    kris109 is offline Professor Kris
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    If the view is invalidated due to a database change in the underlying table, for example this can happen if one of the columns in the table that is referred in the view has been removed, then use CREATE OR REPLACE VIEW command to re-create the view.
    Reply With Quote Reply With Quote
  4. 08-14-2001, 09:07 PM #4
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Not that you HAVE to re-load from source. If the source is the same, you can just re-compile it. Also, if the source in the database is still valid, Oracle will automatically recompile it the next time you try to access it...
    Jeff Hunter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width