Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Auditing table structures...
Hello all,
Is is possible to audit the table structure? i.e. I have a table A which stores the table structure of table B. If I add a column to table B, a newly row will be inserted automatically to table A to keep track the new column characteristic such as name, date of creation, who create the column etc. Is it possible do that by trigger and PL/SQL stored procedures?
Thanks,
Jimmy
Received on Wed Jul 22 1998 - 20:38:17 CDT
![]() |
![]() |