Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Make table read-only
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