How to Shrink Empty Tablespace
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
DBA_DATA_FILES
How to Drop 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
How to Check DataFile Creation Date
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
How to List Tables in Datafile
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
Prepare Tablespace before Data Migration
In the beginning of data migration, we usually recreate some tablespaces to accommodate data from the source. The best way to do this is to… Read More »Prepare Tablespace before Data Migration
Switch Tablespace To Copy
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
How to Check Tablespace Size in Oracle
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