Need Table's Alter History

OraMaster

Hi All,

Does Oracle keep the audit trail for the alterations happen on the tables?
For e.g. add column,drop column,increase/decrease in column size etc.
If yes then how can get such info?

Thanks!
Bhushan

amitpatel66

If you are using a TOAD or SQL Developer then you can get History of the list of commands you have executed in last few days.

OraMaster

Quote:

Originally Posted by amitpatel66

If you are using a TOAD or SQL Developer then you can get History of the list of commands you have executed in last few days.

Thanks for reply. I know that but my alterations happened before very long time.

debasisdas

better define triggers on DDL event to keep track, define the trigger at schema level to keep track of all such changes. on each event keep track by making an entry into a log table. make it an autonomous trigger so that you can commit.

OraMaster

Quote:

Originally Posted by debasisdas

better define triggers on DDL event to keep track, define the trigger at schema level to keep track of all such changes. on each event keep track by making an entry into a log table. make it an autonomous trigger so that you can commit.

Thanks. But my problem was i didn't write any trigger for the same. I followed that practice when this issue came to me.

Need Table's Alter History

re: Need Table's Alter History

re: Need Table's Alter History

re: Need Table's Alter History

re: Need Table's Alter History

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about