Re: how to reset modified date of an object

I can't even begin to imagine what the purpose for such a request but you can

1. alter system set fixed_date = <original modified date of the object>
2. make a pseudo change to the object.
3. voila
4. shutdown and restart the database since I have no idea how to unset the fixed date once it is set.

Onkar N Tiwary wrote:
> hi all,
> I have one simple but interesting question:
> How to reset the modified date of an object in oracle database to its
> original date irrespective of the date it has been modified?
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l