Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to use the dba_unused_col_tabs view and display fieldname ?
Pete Sharman wrote:
>
> 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;
You can have a look in sys.col$ which will give a cryptic name like 'SYS_C00002_02032120:53:49$' for the unused column. I don't know if there is any linkage back to the name
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Thu Mar 21 2002 - 14:56:12 CST