2 Replies Latest reply on May 21, 2009 10:28 AM by Judith Reed

    how to configure database for VPC patch analysis reporting?

      I tried running the sql script @create_patch_kit_schema_oracle.sql

      on our oracle database, and it complains:

       

      ERROR at line 15:

      ORA-00959: tablespace 'BLREPORTS' does not exist

       

      (repeatedly)

      I checked, the database seems to contain the following tablespaces:

       

      SQL> select * from v$tablespace;

       

      TS# NAME INC BIG FLA ENC

      -


      -


      --- --- --- ---

      0 SYSTEM YES NO YES

      1 UNDOTBS1 YES NO YES

      2 SYSAUX YES NO YES

      3 TEMP NO NO YES

      4 USERS YES NO YES

      5 BLADELOGIC YES NO YES

      6 BLADELOGIC_INDEX YES NO YES

      9 BMC_PATROL YES NO YES

       

      What am I doing wrong? Thanks!