Re: how to make statspack package valid again after full import

dbaplusplus_at_hotmail.com wrote:
> I had to change the database character set of my database which
> required
> full export/import. My database had statspack installed. After full
> import everything was working file until I had to run statspack.
>
> Presevring statspack data is not that critial but I was just curious
> whether there is some dovcumented way of doing it. I am sure others
> have run into same problem.
>
> Looks like I have to use spdrop to drop the perfstat user and then
> recreate it using spcreate.

Just for fun run:

SELECT object_type, COUNT(*)
FROM dba_objects
WHERE status = 'INVALID'
GROUP BY object_type;

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)