Re: SYS_LOB query

  • From: Ray Stell <stellr@xxxxxx>
  • To: "Mark W. Farnham" <mwf@xxxxxxxx>
  • Date: Mon, 27 Oct 2014 11:56:43 -0400

On Oct 27, 2014, at 11:41 AM, Mark W. Farnham <mwf@xxxxxxxx> wrote:

> by the way, Jo was mostly correct, but the query on dba_lobs does not include 
> the recycle bin (in case anyone was confused by the thread.)

true, thanks:

SQL> select distinct(object_name) from dba_recyclebin where owner = ‘FRED' and 
object_name like 'BIN%';

OBJECT_NAME
------------------------------
BIN$+KnOFW/UiwngQFLGO6lBQA==$0


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

Other related posts: