Re: immutable LOBs

DA Morgan <damorgan_at_x.washington.edu> writes:

> 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,
>
> CREATE TABLESPACE ro_data ...
>
> CREATE TABLE lobtab (
> row data in tbs1, lob data in ro_data
>
> ALTER TABLESPACE ro_data READ ONLY;

Thanks Daniel,

But, That will work with batch loading the LOBS only.

The intended workflow is:

Create row with empty lob, load one LOB, mark it immutable. Create row with empty lob, load one LOB, mark it immutable. ..

 instead of

Create row with empty lob, load one LOB. Create row with empty lob, load one LOB. mark all immutable, by setting the LOB tablespace to readonly.

Do you know of some object type that mirrors the DBMS_LOB methods but permitts to set a readonly attribute individually for each LOB? Thanks,

Volker

-- 
Volker Apelt