Re: how to find unused table /columns in a database

From: Marc Blum <blum_at_marcblum.de>
Date: Sat, 18 Mar 2006 18:48:53 +0100
Message-ID: <qrho12peou10krv7djdsuakmjt5b5urp2r@4ax.com>

On 16 Mar 2006 01:44:34 -0800, "gpanda28_at_gmail.com" <gpanda28_at_gmail.com> wrote:

> we are using oracle 9i production database and d2k 6i applications.
>is there any way by which i can find the tables/ columns that are not
>in used by applications. So that i can move them out from our
>production database.

One question: why? do they do any harm? are they occupying TB of disk space? make they your backup running much longer? is your life such boring?

--
Marc Blum
mailto:blumXXXSPAMXXX_at_marcblum.de
http://www.marcblum.de

Received on Sat Mar 18 2006 - 11:48:53 CST