Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

How To Move Table to Different TableSpace

How To Move Table to Different TableSpace

How To Move Table to Different TableSpace

 

SYNTAX

ALTER TABLE table_name move TABLESPACE tablespace_name (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);

 

EXAMPLE

ALTER TABLE hr.employee_details move TABLESPACE hr;

OR

ALTER TABLE hr.employee_details move TABLESPACE hr (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);

 

Related Posts
Write a comment