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?