Managing DDL changes

Isabelle_Vela

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

emoreno

In the query profiles table you have query_type that tells if it is a DDL what was executed. However, this data is phase out depending on your data collector setting. You could capture the info in a physical table and keep track if you need it.

Hope this helps.
Eugenia

zvika_gutkin

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