Oracle数据库 删除表中的列

CONN SCOTT/TIGER
DROP TABLE T1;
create table t1 as select * from emp;
insert into t1 select * from t1;

/
--到6000行，构造一个实验用大表T1。

COMMIT;

select EXTENT_ID,FILE_ID,BLOCK_ID,BLOCKS  from
dba_extents where SEGMENT_NAME='T1' AND OWNER='SCOTT';

--删除指定的一列

alter table t1 drop column hiredate;
alter table t1 move tablespace users;
select EXTENT_ID,FILE_ID,BLOCK_ID,BLOCKS  from
dba_extents where SEGMENT_NAME='T1' AND OWNER='SCOTT';

--禁用多列

alter table t1 set unused column comm;
alter table t1 set unused column sal;
alter table t1 set unused column mgr;

--验证是否释放空间

alter table t1 move tablespace users;
select EXTENT_ID,FILE_ID,BLOCK_ID,BLOCKS  from
dba_extents where SEGMENT_NAME='T1' AND OWNER='SCOTT';

--删除多列

alter table t1 drop unused columns;

--验证是否释放空间

alter table t1 move tablespace users;
select EXTENT_ID,FILE_ID,BLOCK_ID,BLOCKS  from
dba_extents where SEGMENT_NAME='T1' AND OWNER='SCOTT';