Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
0


create table t_new compress as select * from all_users
729 rows affected

alter table t_new add x number
update t_new set x = 1
729 rows affected

alter table t_new drop column x
select * from user_unused_col_tabs


TABLE_NAME
COUNT


T_NEW
1


alter table t_new nocompress
alter table t_new drop unused columns
select * from user_unused_col_tabs


TABLE_NAME
COUNT


T_NEW
1


alter table t_new move nocompress
729 rows affected

alter table t_new drop unused columns
select * from user_unused_col_tabs
alter table t_new compress
drop table t_new