| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
-----Original Message-----
From: Katz.C_at_forces.gc.ca [mailto:Katz.C_at_forces.gc.ca]
Sent: Friday, September 24, 2004 10:27 AM
To: lex.de.haan_at_naturaljoin.nl; oracle-l_at_freelists.org
Subject: RE: Unused column names
Lex,
You've answered my question. To answer yours: we had an import that failed
with an "imp-00020 long column too large for column buffer error". The
export had no long columns but there was a note on metalink that pointed to
unused columns (and directmode export) as a possible explanation. Sure
enough the database that provided the export file had a table with unused
columns.
We're a distributed environment with more than a couple of sites. Only one
site has the unused columns. That triggered the dilbert syndrome which
resulted in my question to the list... chaim
http://www.learntorah.net
-----Original Message-----
From: Lex de Haan [mailto:lex.de.haan_at_naturaljoin.nl]
Sent: Friday, September 24, 2004 10:02 AM
To: Katz.C_at_forces.gc.ca; oracle-l_at_freelists.org
Subject: RE: Unused column names
Chaim,
why would you like to know them? those columns are lost forever anyway, except when using regular recovery techniques -- but then the names come back with the recovery :-)
Kind regards,
Lex.
-----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 14:38
To: oracle-l_at_freelists.org
Subject: Unused column names
is it possible to identify the original names of columns that are no longer used (as in ALTER TABLE SET UNUSED COLUMN cname)?
thanks,
chaim
http://www.learntorah.net
http://www.ixora.com.au/ - For DBAs
http://directory.google.com/Top/Society/Religion_and_Spirituality/ - For All
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 24 2004 - 10:25:29 CDT
 |
 |