| LAST DML DATE ON A TABLE [message #79738] |
Sat, 06 July 2002 04:02  |
Meghna
Messages: 6
Registered: November 2001
|
Junior Member |
|
|
We can find object's last created/ altered date of any object from ALL_OBJECTS table.
Simalarly, from where we can get information(last date)
when a particular table was used i.e. used in create, insert, delete or select command.
needed urgently.
|
|
|
|
| Re: LAST DML DATE ON A TABLE [message #79744 is a reply to message #79738] |
Mon, 08 July 2002 00:41  |
I.Nirmala
Messages: 4
Registered: July 2002
|
Junior Member |
|
|
U cannot find the same info, instead try adding two columns say Created_by Varchar2(20),
Last_Modified_Date Date
along with the other columns in your table, and allow your application to fill these columns as and when any DML is issued.
Thanks
-Nirmala
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
