Paula,
I received this issue upon installing STATSPACK on Oracle 8.1.7.4. The key is to run SPDROP before running SPCREATE. Since I haven't upgraded any databases to 10g, I'm not sure how this relates to 10g.