Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> imp-20 on importing a table with a dropped functional index
Hello,
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 - 09:30:51 CDT