Re: READ-ONLY Tables and Views

Ellard_at_DMLIS.zynet.co.uk (Ross Ellard) wrote:

> I have a vague recollection that a note was posted in this newsgroup a
>few months ago talking about an undocumented SQL extension to the
>CREATE TABLE or CREATE VIEW command that made the respective object
>READ-ONLY.
 
> We have a need to create both types of objects as READ_ONLY objects so
>can anybody remind me of the original posting?
 

>Ross Ellard

create view emp_view as select * from emp WITH READ ONLY;

To make a table read only (and this applies to 7.1 and above), you can make the tablespace it is in read only. Alter tablespace X read only. Suggest you read the 7.1 doc addendum before doing so. It affects how you do backups (in a good way, less to back up in the future).

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government Received on Fri Jan 19 1996 - 00:00:00 CET