How to query the creation date of table space in oracle database

To query the creation date of a table space in an Oracle database, you can use the DBA_TABLESPACES view to obtain the table space name and creation date by querying the TABLESPACE_NAME and CREATED columns.

Query the creation date of table space in Oracle database

To query the creation date of table space in Oracle database, you can Use the following method:

DBA_TABLESPACES view

<code class="sql">SELECT
  TABLESPACE_NAME,   -- 表空间名称
  CREATED           -- 创建日期
FROM
  DBA_TABLESPACES;</code>

Example output:

<code class="text">TABLESPACE_NAME  CREATED
------------------ ---------------------
SYSTEM           2022-02-21 03:44:22
USERS            2022-02-21 03:44:35</code>

Note:

• DBA_TABLESPACES The view can only be queried by the DBA or a user with appropriate permissions.
• CREATED Columns are displayed as dates and timestamps in the database time zone.

The above is the detailed content of How to query the creation date of table space in oracle database. For more information, please follow other related articles on the PHP Chinese website!