The UK also benefitted from North Sea oil, but unlike the Norwegians, we don't have a sovereign wealth fund.
Some suggest the money raised went towards tax cuts and contributed to house price inflation. [1]
Although I'm not sure about house price inflation, as there has been similar inflation in Canada and Australia.
[1] https://www.theguardian.com/commentisfree/2014/jan/13/north-...