RE: 11g READ ONLY table
- From: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
- To: <oralrnr@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 9 Jul 2010 09:51:06 -0500
Orlando, From a technical point of view there is now an attribute at the
table level that controls if the table can be written to or not, is this
what you are asking?
OP@ORCL11> create table read_me (anum number);
OP@ORCL11>
OP@ORCL11> select owner, table_name, read_only from dba_tables where
table_name = 'READ_ME';
OWNER TABLE_NAME REA
------------------------------ ------------------------------ ---
OP READ_ME NO
OP@ORCL11>
OP@ORCL11> alter table read_me read only;
OP@ORCL11>
OP@ORCL11> select owner, table_name, read_only from dba_tables where
table_name = 'READ_ME';
OWNER TABLE_NAME REA
------------------------------ ------------------------------ ---
OP READ_ME YES
OP@ORCL11>
-----------------------
Ric Van Dyke
Hotsos Enterprises
-----------------------
Hotsos Symposium
March 6 - 10, 2011
You have to be there, yea I'm talking to you.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Orlando L
Sent: Wednesday, July 07, 2010 11:20 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 11g READ ONLY table
List
Does anyone know how 11g is able to convert read write tables to READ
ONLY and back when the extents are all over mixed in with other tables
in a tablespace?
Orlando.
Other related posts:
