Veronica,
First things first, calm down.
Second, assuming your control file hasn't been totally blasted to hell from
when you started, try the following:
0) shutdown the DB
1) make a backup
2) in the init.ora file, find the rollback_segement line & comment it out,
we don't wa
Are you talking about Support Magic from NAI??
Dick Goulet
Reply Separator
Author: "Shreeni" <[EMAIL PROTECTED]>
Date: 1/18/2002 10:30 AM
Hi list,
Can any body tell me about magic for oracle?
TIA,
Shreeni
Shreenivasa Rao.vcf
Description:
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 pr
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');
Ano
