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: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 18 Oct 2004 07:41:13 -0400
Message-ID: <pan.2004.10.18.11.41.13.193031@sbcglobal.net>


On Mon, 18 Oct 2004 12:12:57 +0200, 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.

"Truncate table" will prevent users from updating any row in the table. It will not prevent inserts.

-- 
Artificial Intelligence is no match for natural stupidity.
Received on Mon Oct 18 2004 - 06:41:13 CDT

Original text of this message

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