Thanks to all for replying. A normal restore from a backup seems to have done the job. We aren't changing the tablespaces so a redirected restore isn't needed. However, I still have some way to go with testing and tuning so....we'll see!
Simon.
"This communication is intended solely for the addressee and is confidential and not for third party unauthorised distribution."
