Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Identifying unused columns

520889Sep 9 2008 — edited Sep 9 2008
Hi,

I'm wondering if there is a way to identify by name the unused (marked) columns in a table?

---select * from ALL_UNUSED_COL_TABS

returns just the COUNT, no column names.


--- Does "desc table" return the valid columns only?
(unused are not returned)

Is it safe to drop the unused columns (not returned by desc).

Thx,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2008
Added on Sep 9 2008
#general-database-discussions
7 comments
9,824 views