ORA-00001 Error

Login as SYS with SYSDBA privilege

SQL > conn sys / as sysdba

Create or replace  ‘STATS$V_$SQLXS’ view

SQL>create or replace view STATS$V_$SQLXS as
               select max(sql_text) sql_text
                , sum(sharable_mem) sharable_mem
                  , sum(sorts) sorts
             , min(module) module
          ,  sum(loaded_versions) loaded_versions
          , sum(fetches) fetches
         , sum(executions) executions
        , sum(loads) loads
         , sum(invalidations) invalidations
      , sum(parse_calls) parse_calls
        , sum(disk_reads) disk_reads
       , sum(buffer_gets) buffer_gets
       , sum(rows_processed) rows_processed
       , max(command_type) command_type
       , address address
      , hash_value hash_value
       , count(1) version_count
     , sum(cpu_time) cpu_time
    , sum(elapsed_time) elapsed_time
    , max(outline_sid) outline_sid
    , max(outline_category) outline_category
     , max(is_obsolete) is_obsolete
   , max(child_latch) child_latch from v$sql  where ( plan_hash_value > 0 or executions > 0 or parse_calls > 0
or disk_reads > 0 or buffer_gets > 0)
group by hash_value, address;

And  then  Login as PERFSTAT and run  the  ‘sptrunc.sql’ script

SQL> @?/rdbms/admin/sptrunc.sql

Table truncated.

     SQL> exec statspack.snap(i_snap_level=>5);

PL/SQL procedure successfully completed.