Re: immutable LOBs

Volker Apelt wrote:

> Oracle 92i
>
> Is there any way to mark LOBs as read-only?
>
> How do you track changes to LOBs and trigger updates
> of meta data like MD5 sum?
>
> AFAIK, Triggers catch access to rows, but not DBMS_LOB.OPEN
> or .WRITE.
>
> Thanks,
>
> Volker

CREATE TABLESPACE ro_data ...

CREATE TABLE lobtab (
recid NUMBER(5),
lobcol BLOB)
LOB (lobcol) STORE AS (TABLESPACE ro_data) TABLESPACE other_tbsp;

ALTER TABLESPACE ro_data READ ONLY;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---