Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Make table read-only

Re: Make table read-only

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Fri, 22 Oct 2004 10:03:51 +0200
Message-ID: <claet8$atj$1@news.BelWue.DE>


Ralf Zwanziger wrote:
> Is ist possible to make an oracle table read-only?
> (without moving it to a read-only tablespace).
> I haven't found any command like "alter table xxx read only" in the
> docs.
>
> Bye,
> Ralf
>

It's not what you asked for, but external tables are readonly, at least as long as you use the ORACLE_LOADER access driver and not the (new in 10g) ORACLE_DATAPUMP one.

Cheers,
Holger Received on Fri Oct 22 2004 - 03:03:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US