Re: imp-20 on importing a table with a dropped functional index

It drops columns which have previously been marked as unused by means of the 'alter table blah set unused column Y' command.

The set unused command simply updates the data dictionary to say the column should be regarded as hence forth non-existent. The 'drop unused' command then physically removes the data out of the rows stored in the table.

If you haven't actually marked any columns for being unused, the 'drop' command will do nothing. Worth a try, however... maybe import is simply confused!

Regards
HJR "C. R. Soza" <crsoza_at_hotmail.com> wrote in message news:c18ea449.0108290630.3d1f8550_at_posting.google.com...
> 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 Sun Sep 02 2001 - 19:35:34 CDT