Skip to main content

Managing DDL changes

  • March 9, 2017
  • 1 reply
  • 0 views

Isabelle_Vela
Forum|alt.badge.img+1

Hello
is there any tool to track the DDL changes performed on a DB (objects created, altered, dropped ... on a date) ?

If we need to create home-made queries, where can we find the altered date for a table/view/projection/sequence ...? I could find only the creation date of schemas/tables/comments and views...

Thanks
Isabelle

1 reply

zvika_gutkin
Forum|alt.badge.img
  • Participating Frequently
  • March 16, 2017

We are having repository for all v_catalog v_monitor tables but you can use the data collector table with custom retention
plus we manage our deployments using flyway