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 the following. SQL> select 'exec dbms_output.put_line(dbms_metadata.get_ddl(''TABLESPACE'',''' || tablespace_name || '''));' ddl… Read More »How to Get Tablespace DDL
ALTER DATABASE MOVE DATAFILE After changing SPFILE location, changing control file location and changing redo logs location, we are going to move or rename data… Read More »How to Move DataFile Location in Oracle
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