Altering table storage

Altering table storage

alter table employee move
STORAGE (
INITIAL 200K
NEXT 200K
PCTINCREASE 0
MAXEXTENTS 50 )
TABLESPACE PROD_DATA_04 ;



# Alter table: modifying a column


ALTER TABLE employee MODIFY (last_name varchar2(35));