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 know what objects in a tablespace for better managing object allocation. In fact, a tablespace is just a logical collection… Read More »What Tables are in a 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