Moving Table to different Tablespace

Moving Table to different Tablespace

-- Moving a Table from one tablespace to another
-- Reset minimum extents
-- Applies to Oracle Server - Enterprise Edition / Information in this document applies to any platform.


~ Syntax:
Alter table table_name move tablespace tablespace_name
(initial=64K minextents=1 maxextents=UNLIMITED);

e.g.,

alter table hr.employee_details move tablespace hr;
OR
alter table hr.employee_details move tablespace hr
(initial=64K minextents=1 maxextents=UNLIMITED);

Note: Some times wrongly a table may be created in different tablespace. To Manage all tables to be reside in respective owner tablespace, the above procedure can be followed.