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

Thread: View Validating

  1. 06-16-2003, 04:04 AM #1
    ganga
    ganga is offline Member
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    View Validating

    Hi,

    I have a created a view Y on Base table X, unexpectedly droped a base table X now my view get invalidated,again i have a created a base X with the same structure what it was earlier. Could any Plz tell me how to validate(Make the status as validate)the existing view without droping and recreating.
    J Gangadhar
    Reply With Quote Reply With Quote
  2. 06-16-2003, 04:22 AM #2
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    alter view view_name compile;

    also

    RTFM
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  3. 06-16-2003, 08:53 AM #3
    htanga
    htanga is offline Member
    Join Date
    Dec 2001
    Posts
    141
    The status's view will automatically turn to VALID when the view will be queried ...
    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