Shrink Empty Tablespaces Dropping empty tablespaces for reclaiming unused space is not a reversible operation, any mistake may cost you a lot in a production… Read More »How to Shrink Empty Tablespace
In previous post, we have talked about how to identify empty tablespaces for dropping. In that post, we cautiously check the status of the tablespace… Read More »How to Drop Empty Tablespace
Data File Creation Date To check the creation date time of data files, we should query V$DATAFILE, not DBA_DATA_FILES. First of all, we format the… Read More »How to Check DataFile Creation Date
Normally, we would like to list tables in a tablespace for better managing segment allocation. In fact, a tablespace is just a logical collection of… Read More »How to List Tables in Datafile
Move Tablespace by RMAN No like we move individual data file to another place by RMAN, changing the location of a tablespace by RMAN is… Read More »Switch Tablespace To Copy
After having the whole picture about the size of the database, we can further check Oracle tablespace usage solely by SQL. Oracle Tablespace Usage Of… Read More »How to Check Tablespace Size in Oracle