Re: 11g READ ONLY table
- From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 9 Jul 2010 22:29:25 +0800
On Wed, Jul 7, 2010 at 11:19 PM, Orlando L <oralrnr@xxxxxxxxx> wrote:
> 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.
>
alter table T read only
should be available from 11g onwards...
If not, you could
a) create a trigger that stop all ins/upd/del, or
b) create an always false check constraint
--
Connor McDonald
===========================
email: connor_mcdonald@xxxxxxxxx
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
Other related posts:
