Re: SYS_LOB query

Dba_lobs should give you this info (where dba_lobs.segment_name corresponds to object_name in dba_objects).

Regards

Jo

On Mon, Oct 27, 2014 at 3:59 PM, Ray Stell <stellr_at_vt.edu> wrote:

> Why is the following result true and how can I map table column to these
> lobs as sysdba? Thanks.
>
> as user fred:
> SQL> select object_name,object_type from all_objects where owner='FRED'
> and object_name like '%SYS%'
>
> OBJECT_NAME OBJECT_TYPE
> ------------------------------ -------------------
> SYS_LOB0000075561C00011$$ LOB
> SYS_LOB0000075561C00010$$ LOB
>
>
> as sysdba:
> SQL> select object_name,object_type from all_objects where owner='FRED'
> and object_name like '%SYS%'
> 2 ;
>
> no rows selected
>
>
>
>

-- 
mvg/regards,

Jo

--
http://www.freelists.org/webpage/oracle-l