Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Issaquah, WA

    Unanswered: Modifying a VIEW while it is in use??

    I'm wondering if there would be a problem in modifying a VIEW while a long process is reading records from it.
    Would the current view last till the end of the session while new requests hit the new view?

    Should I drop the view and then CREATE VIEW or CREATE OR REPLACE VIEW?

    I'm guessing its not a problem since views are not really tables, just quries. So ther are nothing more than a running query in a session. That would mean I can kill or modify the view and the current reader wouldn't feel a thing.. Right?


  2. #2
    Join Date
    Oct 2003
    It the process is include in a transaction, yes, it will not see the difference.

  3. #3
    Join Date
    Oct 2003
    Views are nothing but simple single or complex SELECT statements with or without joins. SELECT never blocks transaction unless u specify explicit locks.

Posting Permissions

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