"alter table <tabname> drop unused columns"
From: C. R. Soza <crsoza_at_hotmail.com>
Date: 29 Aug 2001 07:29:53 -0700
Message-ID: <c18ea449.0108290629.541a961c_at_posting.google.com>
Hello,
Date: 29 Aug 2001 07:29:53 -0700
Message-ID: <c18ea449.0108290629.541a961c_at_posting.google.com>
Hello,
[Quoted] We are hitting a problem as described in oracle note: 148740.1. The workaround Oracle has suggested is to issue: "alter table <tabname> drop unused columns".
My question is, is there any danger in issueing this command ?. Will it drop all empty columns from the table ?. or will it only drop columns which have been previously marked as unused. In our case we haven't marked any columns as unused.
Any clarification of the above command and dangers would be much appreciated
Rgds
Chris Received on Wed Aug 29 2001 - 16:29:53 CEST