RE: tablespace in backup mode

From: Hallas John <John.Hallas_at_btcellnet.net>
Date: Mon, 10 Dec 2001 07:45:25 -0800
Message-ID: <F001.003D8E0E.20011210070523@fatcity.com>

Charlie
Select status from V$backup. If status  = 'ACTIVE' then tablespace in hot backup mode

HTH John

-----Original Message-----
From: Charlie Mengler [mailto:charliem_at_mwh.com] Sent: 10 December 2001 14:26
To: Multiple recipients of list ORACLE-L Subject: tablespace in backup mode

Which table/view do I query to determine if any tablespace has been left in hot backup mode?

--

Charlie Mengler                       Maintenance Warehouse  
charliem_at_mwh.com                      6041 Scripps Summit Ct.
858-831-2229                          San Diego, CA 92131    

Rose are red. Violets are blue. I'm schizophrenic & I am too!
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Charlie Mengler
  INET: charliem_at_mwh.com

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: ListGuru_at_fatcity.com (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).

---

This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately.

---

Received on Mon Dec 10 2001 - 09:45:25 CST