SYS_LOB query

  • From: Ray Stell <stellr@xxxxxx>
  • To: "<oracle-l@xxxxxxxxxxxxx> (oracle-l@xxxxxxxxxxxxx)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 27 Oct 2014 10:59:39 -0400

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



Attachment: signature.asc
Description: Message signed with OpenPGP using GPGMail

Other related posts: