Re: Read Only Tables

How is it better?

What if I have a set of tables used to configure an application, and the total space used by those tables is 1 megabyte.

Once the config is set, don't allow any changes to it by making the tables read only.

There's not much benefit to be found by putting them in a read only tablespace. This is particularly true with apps that assign tablespaces and expect to find the tables where they were originally placed.

It is also much less work.

Jared

On 1/17/06, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
>
> Hi Jared
> I thinks is better to move to a readonly tablespace, I think this
> helps Oracle to optimize its use, but definetively reduces backup
> size.
>
> On 1/16/06, Jared Still <jkstill_at_gmail.com> wrote:
> >
> > The question "How do I make a table read only" has appeared more
> > than once in this forum.
> >
> > The answer has always been "you can't".
> >
> > That answer appears to have been incorrect.
> >
> > This site has an ingenious and effective method for effectively
> > making a table read only.
> >
> > http://oraqa.com/2006/01/09/how-to-set-a-table-in-read-only-mode/
> >
> > I saw this today on Tom Kyte's blog
> > http://tkyte.blogspot.com/2006/01/new-questionanswer-site.html
> >
> > Here's a test:
> >
> > 11:11:41 SQL>create table dv ( id number(12));
> >
> > Table created.
> >
> > 11:11:41 SQL>
> > 11:11:41 SQL>alter table dv add constraint dv_read_only check(1=1)
> disable
> > validate;
> >
> > Table altered.
> >
> > 11:11:41 SQL>
> > 11:11:41 SQL>insert into dv(id) values(1);
> > insert into dv(id) values(1)
> > *
> > ERROR at line 1:
> > ORA-25128: No insert/update/delete on table with constraint
> > (JS001292.DV_READ_ONLY) disabled and
> > validated
> >
> >
> > --
> > Jared Still
> > Certifiable Oracle DBA and Part Time Perl Evangelist
> >
>
>
> --
> Oracle Certified Profesional 9i 10g
> Orace Certified Professional Developer 6i
>
> 8 years of experience in Oracle 7,8i,9i,10g and developer 6i
>

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l