I went from a 6800GT to a 7800GT and saw a signifigant difference. I thought it was a good jump for me. Consider that the X800Pro is slower then the 6800GT and the 7900GT is faster then the 7800GT, I think your jump will be quite noticible.
Well from some prelim reports, oblivion at those settings will require a 7900 for sure. I have seen the videos with in game screens for the game and boy will it tax the gpus for sure. I doubt that the x800 can handle that game at 1280x1024 at mid to high settings.