Oracle Database Notes

Saturday, 13 September 2014

List all recent DDL modifications


set pagesize 200 colsep ' '
col Owner format a20
col Object_Name format a30
col Last_DDL format a20
break on Owner
select Owner, Object_type
Object_Name,
Timestamp Last_DDL
from DBA_OBJECTS
where  SysDate - TO_DATE(TimeStamp,'YYYY-MM-DD:HH24:MI:SS') < 1
order by Owner, Object_Name
/
Posted by Shilpa Rani at 00:22
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2023 (9)
    • ►  April (9)
  • ►  2016 (10)
    • ►  April (6)
    • ►  January (4)
  • ►  2015 (27)
    • ►  September (1)
    • ►  August (6)
    • ►  July (20)
  • ▼  2014 (19)
    • ▼  September (16)
      • Monitoring and Maintainence of Jobs
      • Full Database Refresh Using Export Dump
      • OEM Unreachable
      • Flashback Area Full
      • Max sessions/processes limit Reaching/Reached
      • Database Availability Alert Checks
      • Procedure to add space to tablespace
      • History of Past of Sessions
      • Undo Tablespace Management
      • Temporary Tablespace Management
      • Connected Sessions:Details
      • Tablespace: Free space management
      • ASH and AWR Performance Tuning Scripts
      • List Objects being accessed by a particular SID
      • List all recent DDL modifications
      • Size of db
    • ►  August (2)
    • ►  February (1)
  • ►  2013 (12)
    • ►  December (7)
    • ►  September (3)
    • ►  May (2)

About Me

Shilpa Rani
View my complete profile
Simple theme. Powered by Blogger.