The North Sea Oil paid for the 80's, the main income from it now is tax. The Norway government will still own a lot of their oil.
It will be very expensive for both the UK and Scotland if its a yes vote. I just hope it isn't because I can't see it being beneficial to either party.