| 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
Chaim,
in that case, issuing "alter table drop unused columns" before the import
will do the trick ...
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 15:27
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
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 24 2004 - 09:33:00 CDT
 |
 |