Subject | Shutting down while changing metadata |
---|---|
Author | Aldo Caruso |
Post date | 2012-08-06T12:16:26Z |
Hi,
Normally, when I make a modificacion to the metadata ( DDL ) I shut
down the database because it is not clear to me what happens if I alter
a table or a stored procedure while it is being used or invoked by
another user.
Is it actually necessary to shut down the database in order to do
metadata changes in a production environment ?
Thanks in advance,
Aldo Caruso
Normally, when I make a modificacion to the metadata ( DDL ) I shut
down the database because it is not clear to me what happens if I alter
a table or a stored procedure while it is being used or invoked by
another user.
Is it actually necessary to shut down the database in order to do
metadata changes in a production environment ?
Thanks in advance,
Aldo Caruso