Subject | drop/recreate view in use |
---|---|
Author | Alexandre Benson Smith |
Post date | 2007-12-08T00:49:09Z |
Guys,
I do my best to do any changes to metadata without users connected to
the database, but sometimes, I need to do it when the database is in use.
Last week I had this scenario, I need to recreate a view, but could not
do it because there are some user "using it", it's was hard to find the
person and solve the problem.
What's the possibility to allow FB to recreate (alter) a view that is in
use (the user who is using keep the old view) the newer requests uses
the updated view.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
I do my best to do any changes to metadata without users connected to
the database, but sometimes, I need to do it when the database is in use.
Last week I had this scenario, I need to recreate a view, but could not
do it because there are some user "using it", it's was hard to find the
person and solve the problem.
What's the possibility to allow FB to recreate (alter) a view that is in
use (the user who is using keep the old view) the newer requests uses
the updated view.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br