RE: database decommission checklist
Date: Mon, 29 Jun 2009 04:00:16 -0400
Excellent point. I don't use either feature that often, and hadn't really considered the difference.
From: Timur Akhmadeev [Akhmadeev_at_NetCracker.com] Sent: Monday, June 29, 2009 3:34
To: Bobak, Mark; gus.spier_at_gmail.com; Oracle-L_at_freelists.org Subject: RE: database decommission checklist
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
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.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark Sent: Monday, June 29, 2009 09:02
To: gus.spier_at_gmail.com; Oracle-L_at_freelists.org Subject: RE: database decommission checklist
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...?
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.
http://www.freelists.org/webpage/oracle-l Received on Mon Jun 29 2009 - 03:00:16 CDT