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);
Syed Saad Ali
Syed Saad Ali
AppsDBA Scripts
October 1, 2017
How To Move Table to Different TableSpace
APPS DBAAppsDBA ScriptsDatabase ScriptsScripts
September 1, 2017
Undo Related Queries Part 2
APPS DBAAppsDBA ScriptsScripts
List of All active Transactions
September 1, 2017
Undo Related Queries Part 1
APPS DBAAppsDBA ScriptsScripts
To check Retention Guarantee for Undo Tablespace
September 1, 2017
SQL Queries to Check ACTIVE / INACTIVE Sessions
AppsDBA ScriptsDatabase ScriptsScripts
SQL Queries to Check ACTIVE / INACTIVE Sessions