RE: read only tablespaces

2002-12-19 Thread Fink, Dan
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

2002-12-19 Thread Shao, Chunning
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

2002-12-19 Thread Orr, Steve
Title: RE: read only tablespaces





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


select translate('LNOPQSUVWXYZBCDEGHIJKn;8!###)n9/)3l9)jku9)vum1@',
 '8#)n!9/3lvjkum1;@LNOPQSUVWXYZBCDEGHIJK',
 '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

2002-12-19 Thread Igor Neyman
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

2002-12-19 Thread Richard Ji
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

2002-12-19 Thread Yechiel Adar
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

2002-12-19 Thread Jared . Still
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)vum1@', 
 '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).




RE: read only tablespaces

2002-12-19 Thread Jared . Still
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

2002-12-19 Thread Fink, Dan
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)vum1@', 
 '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).




RE: read only tablespaces

2002-12-18 Thread Fink, Dan
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.


RE: read only tablespaces

2002-12-18 Thread Orr, Steve
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

2002-12-18 Thread Burke, William F (Bill)
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

2002-12-18 Thread Jared . Still
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).