****************************************************************** * Description: SQL for Querying Object Last DDL Modification Time * Compatiablity: RDBMS 10g, 11g, 12c * Date: 23:20 PM EST, 01/09/2017 ****************************************************************** SQL> SELECT object_name, object_type, last_ddl_time FROM dba_objects WHERE owner = 'TEST' AND object_name = 'PART_WORK_HISTORY'; OBJECT_NAME OBJECT_TYPE LAST_DDL_TIME ---------------------------------------- ------------------- -------------------- PART_WORK_HISTORY TABLE 13-NOV-2014 11:48:39
Your Comments