Re: SYS_LOB query
From: Ray Stell <stellr_at_vt.edu>
Date: Mon, 27 Oct 2014 11:33:09 -0400
Message-Id: <D2E10F5F-9B76-4702-97E0-37FDF852E43B_at_vt.edu>
Date: Mon, 27 Oct 2014 11:33:09 -0400
Message-Id: <D2E10F5F-9B76-4702-97E0-37FDF852E43B_at_vt.edu>
On Oct 27, 2014, at 11:14 AM, Jo Holvoet <jo.holvoet_at_gmail.com> wrote:
> Dba_lobs should give you this info (where dba_lobs.segment_name corresponds to object_name in dba_objects).
>
Thanks, Jo. more:
SQL> select segment_name from dba_lobs where owner = ‘FRED';
no rows selected
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 27 2014 - 16:33:09 CET