Thanks Narayana Bojja ... The answer linked is well worth reading. However I'd like to post my *specific* solution in case it might help others.
I fixed the problem myself with a little encouragement from Oracle. On my original SCJP cert from 2009 the 'Candidate' number was of the form:
SR1234567
This is now a valid '
Testing ID', and should be used as such for both Pearson Vue and Oracle CertView.
1) Create a Pearson Vue account, and on the registration page enter 'I already have a testing ID' and use this SR1234567 ID, to avoid getting a new auto-generated one;
2) Create a Certview Account and during the registration process enter this testing ID and the email address from your Pearson Vue account so that the two accounts get linked up.
Now both accounts have the same SR1234567 ID and Oracle CertView has all the old info from 7 years ago ... ah the memories!