RE: database decommission checklist
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: Timur Akhmadeev <Akhmadeev@xxxxxxxxxxxxxx>, "gus.spier@xxxxxxxxx" <gus.spier@xxxxxxxxx>, "Oracle-L@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 29 Jun 2009 04:00:16 -0400
Hi Timur,
Excellent point. I don't use either feature that often, and hadn't really
considered the difference.
-Mark
________________________________________
From: Timur Akhmadeev [Akhmadeev@xxxxxxxxxxxxxx]
Sent: Monday, June 29, 2009 3:34
To: Bobak, Mark; gus.spier@xxxxxxxxx; Oracle-L@xxxxxxxxxxxxx
Subject: RE: database decommission checklist
Mark,
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/glossary.htm#sthref4193
A database opened with the ALTER DATABASE OPEN READ ONLY command. As their name
suggests, read-only databases are for queries only and cannot be modified
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#sthref1224
You can drop items, such as tables or indexes, from a read-only tablespace, but
you cannot create or alter objects in a read-only tablespace.
Thanks,
Timur Akhmadeev
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Bobak, Mark
Sent: Monday, June 29, 2009 09:02
To: gus.spier@xxxxxxxxx; Oracle-L@xxxxxxxxxxxxx
Subject: RE: database decommission checklist
Gus,
Can't you just do:
alter tablespace <tablespace_name> read only;
for each of your application tablespaces? That way, it doesn't matter how the
database is opened...?
-Mark
________________________________
The information transmitted herein is intended only for the person or entity to
which it is addressed and may contain confidential, proprietary and/or
privileged material. Any review, retransmission, dissemination or other use of,
or taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received this
in error, please contact the sender and delete the material from any computer.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
