-
ERROR at line 1:
ORA-01114: IO error writing block to file 3 (block # 2977)
ORA-27072: skgfdisp: I/O error
SVR4 Error: 9: Bad file number
Additional information: 2977
ORA-01114: IO error writing block to file 3 (block # 2977)
ORA-27072: skgfdisp: I/O error
SVR4 Error: 9: Bad file number
Additional information: 2977
ORA-06512: at line 34
I recieve the preceeding errors whilst running a piece of PL/SQL.
What puzzles me is the success depends on the OS user running it.
If I log on as oracle the procedure is successful. If I log on as myself I get the error you see there, i'm also sure this wasn't happening on Friday.
Any ideas. I'm not even sure what the error means. I'm guessing one of my datafiles is corrupted in some way.
-
If it depends on the user, could it be an issue of privileges?
What does the PL/SQL do?
-
Damned fine call there my man.
One of the guys here took my user ouit of the 'dba' group.
It was screwing a couple of things up.
Put myself back in the group and it's all ok.