Re: SYS_LOB query

From: Ray Stell <stellr_at_vt.edu>
Date: Mon, 27 Oct 2014 11:56:43 -0400
Message-Id: <754D86B0-A429-42A4-83AC-9656C3C562C0_at_vt.edu>

On Oct 27, 2014, at 11:41 AM, Mark W. Farnham <mwf_at_rsiz.com> 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

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

Received on Mon Oct 27 2014 - 16:56:43 CET