Redefine table after SET UNUSED column
Hello,
OS: HPUX
DB version: 11.2.0.4
I have remove a table from a column with 100millions rows. As it took too much time I decided to do mark it as UNUSED with the following command;
ALTER TABLE TAB1 SET UNUSED column1;
It was fast and everything fine.
Now I would like to rescue the space used by the column and I want to do it online using DBMS_REDEFINITION
I have read some post and try it, but the table definition doesn't change and the unused columns remain. In fact the unused column is also created in the interim table
Steps I perform: