Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

STATSPACK export/import

automanOct 4 2004 — edited Oct 11 2004

Oracle 9.2.0.5 on HP-UX and WinXP.

I have exported the PERFSTAT user from a database on HP-UX:

exp file=perfstat.dmp owner=perfstat

and imported into an identical database on Windows XP:

imp file=perfstat.dmp full=y ignore=y

But I receive several errors and no spreport is generated.

ERROR: Database/Instance does not exist in STATS$DATABASE_INSTANCE

ERROR: Begin Snapshot Id specified does not exist for this database/instance

ERROR: End Snapshot Id specified does not exist for this database/instance

WARNING: timed_statitics setting changed between begin/end snaps: TIMINGS ARE IN
VALID

Is there anyway to run the spreport into this target database on windows?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2004

Added on Oct 4 2004

#general-database-discussions

2 comments

433 views