RE: SYS_LOB query

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Mon, 27 Oct 2014 11:29:40 -0400
Message-ID: <18e901cff1fa$d4370f90$7ca52eb0$_at_rsiz.com>

select owner,table_name,column_name from dba_tab_columns where owner = 'FRED' and data_type like '%LOB';  

would probably be useful if there are not too many other FRED LOBs.  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ray Stell
Sent: Monday, October 27, 2014 11:00 AM
To: <oracle-l_at_freelists.org> (oracle-l_at_freelists.org) Subject: SYS_LOB query  

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      

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

Received on Mon Oct 27 2014 - 16:29:40 CET