Re: How to use the dba_unused_col_tabs view and display fieldname ?

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 21 Mar 2002 09:17:22 -0800
Message-ID: <a7d4j202oqa@drn.newsguy.com>

In article <3c99cfe7$0$18519$e4fe514c_at_dreader4.news.xs4all.nl>, "Richard" says...
>
>Hi there,
>
>when i run a select * from dba_unused_col_tabs; the result is :
>
>
>OWNER TABLE_NAME COUNT
>============================== ============================== ========
>TEST DEPT 1
>
>But i need to see what attribuut is delete, is this possible ?
>
>
>THNX
>
>Richard
>
>

Nope, once it's marked unused I don't believe there's any way to see what the column was.

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Thu Mar 21 2002 - 11:17:22 CST