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!

user$ table

happy10319Aug 24 2007 — edited Aug 24 2007

Hi,
I found this in Note:148740.1
select 'ALTER TABLE '||u.name||'.'||o.name||' DROP UNUSED COLUMNS;'
from user$ u, obj$ o, col$ c;
What do the user$ , obj$ , col$ tables contain ?
Many thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 21 2007

Added on Aug 24 2007

#general-database-discussions

3 comments

777 views