Search notes:

Oracle: DBMS_LOBUTIL

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

inode

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;
Github repository Oracle-Patterns, path: /Installed/dbms/lobutil/inode.sql

See also

Oracle DBMS PL/SQL packages, dbms_lob

Index