How To Move Table to Different TableSpace
October 1, 2017
APPS DBA, AppsDBA Scripts, Database Scripts, Scripts
![How To Move Table to Different TableSpace](https://syedsaadali.com/wp-content/uploads/2023/05/SyedSaadAli_ACE_linkedin-e1685600570483.png)
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