Cannot alter a tablespace online
We transferered datafiles from 1 disk to another.
On fedora core 4
On oracle 10g.
the first 2 datafile went ok.
The last one is giving us trouble.
When we try to alter the tablespace online, it gives us the error:
"WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!"
MMNL absent for 26040 secs; Foregrounds taking over
The datafile are online. And seem ok.
The tablespace does not want to go online.
It is a big datafile. But should go well, it went well with the first 2 datafiles.