8 Replies Latest reply: Nov 29, 2012 9:58 PM by 974967 RSS

    select TOOLSREL from PSSTATUS; ORA-00942: table or view does not exist

    974967
      hi,everybody

      I have installed the PeopleSoft Demo DataBase using DCW.And the result is below:
      ---------------------------------------
      SQL Tables: 939 Temp Tables: 8389 Indexes: 9104
      Ended: Fri Nov 23 18:19:18 2012
      Successful completion
      ExitCode: 0
      Error: false

      Installation Complete

      Congratulations. Peoplesoft Database Configuration has been successfully
      installed to:

      /dbfs/people/opt/PS

      PRESS <ENTER> TO EXIT THE INSTALLER:
      ----------------------------------------
      But when I run the query :sqlplus people/peop1e and select TOOLSREL from PSSTATUS;
      It happens:
      ERROR at line 1:
      ORA-00942: table or view does not exist. My PeopleTools version is 8.52 and PeopleSoft HCM is 9.1 .
      I have installed the database twice,the probloems are same.
      Thanks a lot ~