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
DBA_DATA_FILES
What Tables are in a Datafile
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
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