Database Administration (MOSC)

MOSC Banner

Redefine table after SET UNUSED column

edited Jun 2, 2016 4:39AM in Database Administration (MOSC) 10 commentsAnswered

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center