Use 'QUIESCE' command which doesn't allow all users ( except SYSADM, SYSMAINT, DBADM, or SYSCTRL ) to connect to the database until the 'UNQUIESCE' command is given.
For example:
-- Forces off all users with connections to an instance
quiesce instance <Instance_Name> immediate force connections
-- Forces off all users with connections to the database
quiesce database <Database_Name> immediate force connections
For example:
-- Forces off all users with connections to an instance
quiesce instance <Instance_Name> immediate force connections
-- Forces off all users with connections to the database
quiesce database <Database_Name> immediate force connections
No comments :
Post a Comment