Creation Date

How to Check User Creation Date in Oracle

by Ed Chen
July 18, 2022September 2, 2022

User Creation Date To check the creation date for a specific user, we can query ALL_USERS. SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'; Session altered. SQL>… Read More »

How to Check DataFile Creation Date

by Ed Chen
July 15, 2022June 17, 2022

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 Tablespace Creation Date

by Ed Chen
May 30, 2022June 10, 2022

Tablespace Create Time There's no direct way to know the creation date of a tablespace, because either DBA_TABLESPACES or V$TABLESPACE doesn't have such information. But… Read More »

How to Check Oracle Table Creation Date

by Ed Chen
June 23, 2021June 2, 2022

We usually retrieve table information from ALL_TABLES, but it has no table creation date. This is because table is also an object type, so we… Read More »

How to Check Database Creation Date

by Ed Chen
June 21, 2021January 12, 2023

Database Creation Date A simple way that can check the creation date of a database. When the data is running, no matter the instance is… Read More »