view unused columns

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 8 Nov 2002 10:32:02 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702E5FD0B@lnewton.leeds.lfs.co.uk>

Hi Steve,

we don't have any unused columns here, but a quick check in DICT shows the following :

SELECT * FROM dict
WHERE table_name LIKE '%UNUS%';

ALL_UNUSED_COL_TABS
DBA_UNUSED_COL_TABS
USER_UNUSED_COL_TABS You will probably get the info you need from there - or as a starting place anyway.

HTH Regards,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Steven [mailto:askme_at_nowhere.com]
Posted At: Friday, November 08, 2002 10:19 AM Posted To: server
Conversation: view unused columns
Subject: view unused columns

Hi,

I was wondering if it is at all possible to view columns in the database that have been set to unused? I can't seem to find this in the oracle documentation. Received on Fri Nov 08 2002 - 04:32:02 CST