Created date from the Oracle table :
To know the original created date of a particular table there is a view called "dba_objects".
here is the view description
SYSTEM@orcl:SQL>desc dba_objects
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(30)
In this view there is a column named "created " exists in the data dictionary dba_objects view.
using this created we can get the details when was table created.
you can use the following query to get the date.
SELECT CREATED FROM DBA_OBJECTS
WHERE OBJECT_TYPE = 'TABLE'
AND OBJECT_NAME = 'USERDETAILS';
sample out put will be :
CREATED
---------
13-FEB-18
To know the original created date of a particular table there is a view called "dba_objects".
here is the view description
SYSTEM@orcl:SQL>desc dba_objects
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(30)
In this view there is a column named "created " exists in the data dictionary dba_objects view.
using this created we can get the details when was table created.
you can use the following query to get the date.
SELECT CREATED FROM DBA_OBJECTS
WHERE OBJECT_TYPE = 'TABLE'
AND OBJECT_NAME = 'USERDETAILS';
sample out put will be :
CREATED
---------
13-FEB-18
No comments:
Post a Comment
Thanks for giving comments!!