thanks you were right, my system tablespace was running out of room. Hopefully it should work now.!!!