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 ?
In article <3C9A48EC.3E56_at_yahoo.com>, Connor says...
>
>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..."
FAIAP, that's what I said. DOesn't tie back to the original column name in any way - unless Connor has some really weird naming conventions! (Sorry Connor, couldn't resist).
HTH. Additions and corrections welcome.
Pete
SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Thu Mar 21 2002 - 22:54:25 CST