RE: Unused column names

Mark,
On Oracle9i there are two: user_tab_cols and user_tab_columns. user_tab_cols
is undocumentend in 9i and its the one I'm looking at. Thanks for the info
about 10g
chaim


-----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>


--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: