RE: read only tablespaces
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!###)n9http://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).
RE: read only tablespaces
Shao,
No mean spirited replies that I can see.
At least 2 replies actually gave a technical answer to your question.
The answer is easily found in the documentation.
Do you have official Oracle Installation CD's?
If so, the documentation CD is included. Install it on your
desktop/laptop/
wherever you can get to it easily.
If you don't have the CD's, all of the documentation is online at
otn.oracle.com.
Jared
"Shao, Chunning" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/19/2002 07:29 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: read only tablespaces
Is this group suppose to be helpful or for some people just to show their
ego?
I do not know something you think is obvious, but I also know something
you might not know, which to me is quite easy. It is a learning process,
isn't it?
One thing I notice is, for some really learned person, they are really
nice and patient. For those people who is mean, are you really that
knowledgable?
-Original Message-
Sent: Thursday, December 19, 2002 9:55 AM
To: Multiple recipients of list ORACLE-L
Ah, once again, we are deeply indebted to Jared for his 'perls' of
wisdom...
-Original Message-
Sent: Wednesday, December 18, 2002 4:29 PM
To: Multiple recipients of list ORACLE-L
Or the Oxford Encyclopedic (sp?) Dictionary of the English Language
should you wish a truly authoritative source. ;)
"Fink, Dan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/18/2002 02:14 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:RE: read only tablespaces
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Shao, Chunning
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:
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).
RE: read only tablespaces
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!###)n9http://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).
Re: read only tablespaces
Shao We operate of the principle of GIGO - Garbage In, Garbage Out. The people on this list expect you to write clear questions if you want clear answers. Sometimes a questions like yours allow us to horse around a little. All in good will and between friends. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, December 19, 2002 5:29 PM > Is this group suppose to be helpful or for some people just to show their ego? > > I do not know something you think is obvious, but I also know something you might not know, which to me is quite easy. It is a learning process, isn't it? > > One thing I notice is, for some really learned person, they are really nice and patient. For those people who is mean, are you really that knowledgable? > > > > -Original Message- > Sent: Thursday, December 19, 2002 9:55 AM > To: Multiple recipients of list ORACLE-L > > > Ah, once again, we are deeply indebted to Jared for his 'perls' of wisdom... > > -Original Message- > Sent: Wednesday, December 18, 2002 4:29 PM > To: Multiple recipients of list ORACLE-L > > > Or the Oxford Encyclopedic (sp?) Dictionary of the English Language > should you wish a truly authoritative source. ;) > > > > > > "Fink, Dan" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 12/18/2002 02:14 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:RE: read only tablespaces > > > 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). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Shao, Chunning > 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: Yechiel Adar 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).
RE: read only tablespaces
Come on now, these guys are just joking. I don't see any egos or mean
replies.
You asked which dictionary instead of which data dictionary view.
It is a learning process and we should all have a little fun. :)
-Original Message-
Sent: Thursday, December 19, 2002 10:30 AM
To: Multiple recipients of list ORACLE-L
Is this group suppose to be helpful or for some people just to show their
ego?
I do not know something you think is obvious, but I also know something you
might not know, which to me is quite easy. It is a learning process, isn't
it?
One thing I notice is, for some really learned person, they are really nice
and patient. For those people who is mean, are you really that
knowledgable?
-Original Message-
Sent: Thursday, December 19, 2002 9:55 AM
To: Multiple recipients of list ORACLE-L
Ah, once again, we are deeply indebted to Jared for his 'perls' of wisdom...
-Original Message-
Sent: Wednesday, December 18, 2002 4:29 PM
To: Multiple recipients of list ORACLE-L
Or the Oxford Encyclopedic (sp?) Dictionary of the English Language
should you wish a truly authoritative source. ;)
"Fink, Dan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/18/2002 02:14 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: read only tablespaces
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Shao, Chunning
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: Richard Ji
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).
Re: read only tablespaces
What is obvious here, is that you don't do your homework (RTFMing) before asking questions. That's why you get, what you asked for :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 19, 2002 10:29 AM > Is this group suppose to be helpful or for some people just to show their ego? > > I do not know something you think is obvious, but I also know something you might not know, which to me is quite easy. It is a learning process, isn't it? > > One thing I notice is, for some really learned person, they are really nice and patient. For those people who is mean, are you really that knowledgable? > > > > -Original Message- > Sent: Thursday, December 19, 2002 9:55 AM > To: Multiple recipients of list ORACLE-L > > > Ah, once again, we are deeply indebted to Jared for his 'perls' of wisdom... > > -Original Message- > Sent: Wednesday, December 18, 2002 4:29 PM > To: Multiple recipients of list ORACLE-L > > > Or the Oxford Encyclopedic (sp?) Dictionary of the English Language > should you wish a truly authoritative source. ;) > > > > > > "Fink, Dan" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 12/18/2002 02:14 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:RE: read only tablespaces > > > 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). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Shao, Chunning > 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: Igor Neyman 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).
RE: read only tablespaces
Title: RE: read only tablespaces
Here's the specific SQL query that needs to be run:
select translate('LNOPQSUVWXYZBCDEGHIJKn;8!###)n9
'8#)
'F. aRMedthmfinulT!') "Well..."
from DICTIONARY
where table_name='DICTIONARY'
/
:-) :-) :-)
-Original Message-
From: Burke, William F (Bill) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 4:49 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: read only tablespaces
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-
From: Fink, Dan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 4:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: read only tablespaces
I would suggest Funk & Wagnells or Webster's New College Edition
-Original Message-
From: Shao, Chunning [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
Subject: read only tablespaces
which dictionary should I check to see whether a tablespace is read-only or read-write?
thanks for your help.
RE: read only tablespaces
Is this group suppose to be helpful or for some people just to show their ego?
I do not know something you think is obvious, but I also know something you might not
know, which to me is quite easy. It is a learning process, isn't it?
One thing I notice is, for some really learned person, they are really nice and
patient. For those people who is mean, are you really that knowledgable?
-Original Message-
Sent: Thursday, December 19, 2002 9:55 AM
To: Multiple recipients of list ORACLE-L
Ah, once again, we are deeply indebted to Jared for his 'perls' of wisdom...
-Original Message-
Sent: Wednesday, December 18, 2002 4:29 PM
To: Multiple recipients of list ORACLE-L
Or the Oxford Encyclopedic (sp?) Dictionary of the English Language
should you wish a truly authoritative source. ;)
"Fink, Dan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/18/2002 02:14 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: read only tablespaces
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Shao, Chunning
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).
RE: read only tablespaces
Ah, once again, we are deeply indebted to Jared for his 'perls' of wisdom...
-Original Message-
Sent: Wednesday, December 18, 2002 4:29 PM
To: Multiple recipients of list ORACLE-L
Or the Oxford Encyclopedic (sp?) Dictionary of the English Language
should you wish a truly authoritative source. ;)
"Fink, Dan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/18/2002 02:14 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: read only tablespaces
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).
RE: read only tablespaces
Or the Oxford Encyclopedic (sp?) Dictionary of the English Language
should you wish a truly authoritative source. ;)
"Fink, Dan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/18/2002 02:14 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: read only tablespaces
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).
RE: read only tablespaces
Title: RE: Regular Expressions in SQL 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-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 18, 2002 4:15 PMTo: Multiple recipients of list ORACLE-LSubject: RE: read only tablespaces I would suggest Funk & Wagnells or Webster's New College Edition -Original Message-From: Shao, Chunning [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 18, 2002 2:34 PMTo: Multiple recipients of list ORACLE-LSubject: read only tablespaces which dictionary should I check to see whether a tablespace is read-only or read-write? thanks for your help.
RE: read only tablespaces
Title: RE: Regular Expressions in SQL see page 2-137 of the Oracle supplied Reference Manual (v 8.1.6+ docs) Oracle part number A76961-01 -Original Message-From: Shao, Chunning [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 18, 2002 2:34 PMTo: Multiple recipients of list ORACLE-LSubject: read only tablespaces which dictionary should I check to see whether a tablespace is read-only or read-write? thanks for your help.
RE: read only tablespaces
Title: RE: Regular Expressions in SQL I would suggest Funk & Wagnells or Webster's New College Edition -Original Message-From: Shao, Chunning [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 18, 2002 2:34 PMTo: Multiple recipients of list ORACLE-LSubject: read only tablespaces which dictionary should I check to see whether a tablespace is read-only or read-write? thanks for your help.
read only tablespaces
Title: RE: Regular Expressions in SQL which dictionary should I check to see whether a tablespace is read-only or read-write? thanks for your help.
