RE: Unused column names
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'mark.powell@xxxxxxx'" <mark.powell@xxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 24 Sep 2004 13:16:47 -0400
Me either.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Powell, Mark D [mailto:mark.powell@xxxxxxx]
Sent: Friday, September 24, 2004 11:56 AM
To: oracle-l@xxxxxxxxxxxxx
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.
-- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Katz.C@xxxxxxxxxxxx
Sent: Friday, September 24, 2004 11:29 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx]
Sent: Friday, September 24, 2004 10:51 AM
To: 'Katz.C@xxxxxxxxxxxx'; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx [mailto:Katz.C@xxxxxxxxxxxx]
Sent: Friday, September 24, 2004 10:27 AM
To: lex.de.haan@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxx]
Sent: Friday, September 24, 2004 10:02 AM
To: Katz.C@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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.
-------------------------------
visit http://www.naturaljoin.nl <http://www.naturaljoin.nl>
-------------------------------
skype me <RENAMED_callto://lexdehaan>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
