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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/19/2002 07:21 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [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.net
--
Author: Fink, Dan
INET: [EMAIL PROTECTED]
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: [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).
