| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> FW: Unused column names
That is because I read the view name wrong; it should be dba_tab_cols not
dba_tab_columns which is the view we are all familar with. dba_tab_cols
does indeed exist on my 9.2 systems. -- Mark D Powell --
-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us]
Sent: Friday, September 24, 2004 1:17 PM
To: 'mark.powell_at_eds.com'; oracle-l_at_freelists.org
Subject: RE: Unused column names
Me either.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Powell, Mark D [mailto:mark.powell_at_eds.com]
Sent: Friday, September 24, 2004 11:56 AM
To: oracle-l_at_freelists.org
Subject: RE: Unused column names
The dba_tab_columns.hidden_column entry appears to be a 10g addition. I do not see this column on my 9.2.0.4 or .5 systems. It is documented in the 10g Reference manual entry for the view all_tab_columns.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Katz.C_at_forces.gc.ca
Sent: Friday, September 24, 2004 11:29 AM
To: oracle-l_at_freelists.org
Subject: RE: Unused column names
Tom,
Thanks
The information that might help us is in the (oracle 9i
undocumented)user_tab_cols.
The fields hidden_column field identifies the unused columns and the
internal_column_id together with some other fields may allow us to to
establish their identity (will be able to tell if they were old columns that
were set unused and then re-added or new columns added and then set
unused)... I mentioned - this is a real dilbert exercise Dropping the column
will allow export/import as Lex pointed out. chaim
-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us]
Sent: Friday, September 24, 2004 10:51 AM
To: 'Katz.C_at_forces.gc.ca'; oracle-l_at_freelists.org
Subject: RE: Unused column names
Chaim,
Have you looked at the USER_UNUSED_COL_TABS or DBA_UNUSED_COL_TABS view?
Tom Mercadante
Oracle Certified Professional
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 24 2004 - 12:19:37 CDT
 |
 |