Re: SYS_LOB query

  • From: Ray Stell <stellr@xxxxxx>
  • To: Jo Holvoet <jo.holvoet@xxxxxxxxx>
  • Date: Mon, 27 Oct 2014 11:33:09 -0400

On Oct 27, 2014, at 11:14 AM, Jo Holvoet <jo.holvoet@xxxxxxxxx> 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

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2014