dbms_lobutil contains diagnostic and utility functions for 11g LOBs.
The API that is exposed through dbms_lobutil, or its underlying data structures, are subject to possibly backwards-incompatible changes.
The diagnostic API offered in dbms_lobutil are provided separately from dbms_lob to avoid clutter.
Because this diagnostic API is intended for (Oracle-) internal developers, QA and DDR, Oracle does not seem to document this API for end-users.
GetInode
create table lu (
c clob
);
declare
c clob;
begin
dbms_lob.createTemporary(c, true);
dbms_lob.append(c, 'foo bar baz');
insert into lu values (c);
end;
/
select
t.inode.lobid lobid,
t.inode.flags flags,
t.inode.length length,
t.inode.version version,
t.inode.extents extents,
t.inode.lhb lhb -- lhb dba
from (
select
dbms_lobutil.getInode(c) as inode
from
lu
) t;
drop table lu;