Home / APPS DBA / 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);

 

........Subsribe OracleSolutions.pk........
OracleSolutions.pk is exclusively meant to guide the newbies to Learn and Share.

About oracle.solutions

Check Also

ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors

ERROR ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors ORA-06508: PL/SQL: could not find program unit being …

Leave a Reply