How to see what time which database object structure is modified
Amuber
System environment:
1, operating system: Windows 2000
2, Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition
3, installation path: c: / oracle
Description:
SQL> Col Object_name Format A20
SQL> SELECT Object_name, - Object Name
Object_type, - Object Type
To_char (create, 'YYYY-MON-DD HH24: MI') CREATE_TIME, - creation time
To_char (last_ddl_time, 'YYYY-MON-DD HH24: MI') MOD_TIME, - Modification Time
TimeStamp, - Timestamp
STATUS - Status
From user_Objects
WHERE to_CHAR (Last_DDL_Time, 'YYYYMMDD')> '& Date Variable';