RE: read only tablespaces

From: Orr, Steve <sorr_at_rightnow.com>
Date: Thu, 19 Dec 2002 07:21:15 -0800
Message-ID: <F001.0051E3AD.20021219072115@fatcity.com>

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: Orr, Steve
  INET: sorr_at_rightnow.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).

Received on Thu Dec 19 2002 - 09:21:15 CST