Tag Archives: oracle tablespace

Re-Organize / Defrag database schema using ALTER TABLE MOVE TABLESPACE option

There are several ways for a complete reorganization and space reclamation:- EXPORT/IMPORT DBMS_REDEFINITION CREATE TABLE AS SELECT (CTAS) DATA PUMP ALTER TABLE MOVE TABLESPACE This post provides a trick to reorganize all schema objects using the following script using ‘ALTER TABLE MOVE TABLESPACE’ … Continue reading

Posted in Database Technologies, Oracle | Tagged , , , , , , | Leave a comment