Sean:
Although probably you won't use it right now but in Oracle 9i there is
a new function called "Quiesce the database" which will put the database
into a partially available state. During this time, no ongoing non-DBA
transactions, queries, or PL/SQL statements are allowed. Several maintenance
operations could benefit from this feature.
SQL> Alter SYSTEM QUIESCE RESTRICTED;
Kevin
-----Original Message-----
Sean
Sent: Wednesday, September 26, 2001 7:25 AM
To: Multiple recipients of list ORACLE-L
If I wish to do work on a database logging in to server itself and want to
prevent users from accessing the system via network is there another way to
do this if I don't want to use the "enable restricted session"
functionality. I'm thinking there's probably a neat way to utiltise the
listener process but have not figured it out.
Also what If I need to work on DB over network but don't want any other
users using DB what can I do to prevent their connecting?
Sean :)
Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA ---> End 2002 deadline =:-O
[0%] OCP Oracle9i DBA
-------------------------------- ------------
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode]
Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
"Nobody loves me but my mother... and she could be jivin' too." - BB King
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: O'Neill, Sean
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Tsay
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
