Oracle-L: RE: read only tablespaces

From: Fink, Dan <Dan.Fink_at_mdx.com>
Date: Thu, 19 Dec 2002 11:45:17 -0800
Message-ID: <F001.0051ECDE.20021219114517@fatcity.com>

That's going in my DBA Script Toolkit!

-----Original Message-----
Sent: Thursday, December 19, 2002 12:26 PM To: Multiple recipients of list ORACLE-L

That's a keeper!

"Orr, Steve" <sorr_at_rightnow.com>
Sent by: root_at_fatcity.com
12/19/2002 07:21 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: read only tablespaces

Here's the specific SQL query that needs to be run:

select translate('LNOPQSUVWXYZBCDEGHIJKn;8!###)n9</)3l9)jku9)v<um<1@', 
                 '8#)<n!9/3lvjkum1;@LNOPQSUVWXYZBCDEGHIJK', 
                 'F. aRMedthmfinulT!') "Well..."

from DICTIONARY
where table_name='DICTIONARY'
/

:-) :-) :-)

-----Original Message-----
Sent: Wednesday, December 18, 2002 4:49 PM To: Multiple recipients of list ORACLE-L

Personally I would try dba_tablespaces and check the status column... online, offline or read only. If it's online, it's read-write, read only speaks for itself.
Good to see sarcasm hasn't left the list. Regards,
Bill Burke
"The Kinder and Gentler DBA"
www.OracleGuru.com
www.KBMotorsports.biz
-----Original Message-----
Sent: Wednesday, December 18, 2002 4:15 PM To: Multiple recipients of list ORACLE-L

I would suggest Funk & Wagnells or Webster's New College Edition -----Original Message-----
Sent: Wednesday, December 18, 2002 2:34 PM To: Multiple recipients of list ORACLE-L

which dictionary should I check to see whether a tablespace is read-only or read-write?
thanks for your help.

--

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

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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).
--

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

Author: Fink, Dan
INET: Dan.Fink_at_mdx.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------