There are two things you can do:
1) turn Oracle auditing on for ddl statements to see who's doing them.
2) if you know the username where things are being messed up, you could
revoke the create session privilege find out who screams.
I'd also look at that table and see who has index
Harvinder,
If you want time in a date column, you've got to tell Oracle what to put in
there, otherwise it assumes 00:00:00. In your statement there is no time
therefore none got recorded. So what you need is:
insert into dd
values(to_date('04-JUL-01 23:59:59','DD-MON-YY HH24:MI:SS');
