Offline a Temporary Tablespace Theoretically, you can't take the whole temporary tablespaces offline. SQL> alter tablespace temp offline; alter tablespace temp offline * ERROR at… Read More »How to Alter Temporary Tablespace Offline
I usually move some tables for data reorganization, and I found the procedure is pretty routine:Moving the table.Rebuilding indexes related to this table.Analyzing all segments… Read More »How to Move Tables by SQL Script
We can compose the execution statement for getting the definition of all tablespaces by DBMS_METADATA.GET_DDL, just like we do for getting DDL of a table.… Read More »How to Get Tablespace DDL
Move Data File After changing SPFILE location, changing control file location and changing redo logs location, we are going to move or rename data files.… Read More »How to Move Data File Location
Moving a table is actually a reorganization process, The database will copy the original data to the new place. In which, the data will be… Read More »Must Dos after Moving a Table
The chained row is a row which is too large to fit into one single data block when it is first inserted. In row chaining,… Read More »How to Reduce Chained Row