Re: BLOBs

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 21 Jun 2001 10:06:24 +0100
Message-ID: <3b31b911$0$15024$ed9e5944@reading.news.pipex.net>

"Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote in message news:3B30D458.D0DF49CD_at_attws.com...
>
>
> Niall Litchfield wrote:
>
> > bad day daniel?
>

<snip>
> No. But getting a table that contains data that you can't identify means
that
> likely you don't need it either. Sort of like getting a table full of
integer
> fields but no idea what the integers relate to. Not information, not data,
> just junk.

Those of us who work with undocumented systems from 3rd parties (or who have as this guy has 'inherited' some old stuff) are a little mor circumspect about killing something off that we can't identify. I'd certainly want to at least look at the data using dbms_lob and a file viewer or some such first.

Mind you there is an argument that if you drop the table you can pretty quickly rely on users to identify the missing stuff for you!!

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Thu Jun 21 2001 - 04:06:24 CDT