RE: 11g READ ONLY table

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: