1 Reply Latest reply: Feb 1, 2013 6:44 AM by Nicolas.Gasparotto RSS

    error running dbowner.sql

    user584098
      Hi,

      Trying to ELM and Peopletools, getting an error when running the dbowner.sql script "ERROR at line 1:
      ORA-00959: tablespace 'PSDEFAULT' does not exist"



      Output:

      SQL> CONNECT PS/PS;
      Error accessing PRODUCT_USER_PROFILE
      Warning: Product user profile information not loaded!
      You may need to run PUPBLD.SQL as SYSTEM
      Connected.
      SQL> CREATE TABLE PSDBOWNER (DBNAME VARCHAR2(8) NOT NULL, OWNERID VARCHAR2(8) NO
      T NULL ) TABLESPACE PSDEFAULT;
      CREATE TABLE PSDBOWNER (DBNAME VARCHAR2(8) NOT NULL, OWNERID VARCHAR2(8) NOT NUL
      L ) TABLESPACE PSDEFAULT

      *
      ERROR at line 1:
      ORA-00959: tablespace 'PSDEFAULT' does not exist


      SQL> CREATE UNIQUE INDEX PS_PSDBOWNER ON PSDBOWNER (DBNAME) TABLESPACE PSDEFAULT
      ;
      CREATE UNIQUE INDEX PS_PSDBOWNER ON PSDBOWNER (DBNAME) TABLESPACE PSDEFAULT
      *
      ERROR at line 1:
      ORA-00942: table or view does not exist


      SQL> CREATE PUBLIC SYNONYM PSDBOWNER FOR PSDBOWNER;

      Synonym created.

      SQL> CONNECT system/manager;
      Connected.
      SQL> REVOKE DBA FROM PS;

      Revoke succeeded.

      SQL> ALTER USER PS QUOTA UNLIMITED ON PSDEFAULT;
      ALTER USER PS QUOTA UNLIMITED ON PSDEFAULT
      *
      ERROR at line 1:
      ORA-00959: tablespace 'PSDEFAULT' does not exist


      SQL>
      SQL> spool off
      SQL> @E:\PT8.52\scripts\nt\DBOWNER.sql


      Thanks for your help!
        • 1. Re: error running dbowner.sql
          Nicolas.Gasparotto
          user584098 wrote:
          Hi,
          ...
          SQL> CREATE TABLE PSDBOWNER (DBNAME VARCHAR2(8) NOT NULL, OWNERID VARCHAR2(8) NO
          T NULL ) TABLESPACE PSDEFAULT;
          CREATE TABLE PSDBOWNER (DBNAME VARCHAR2(8) NOT NULL, OWNERID VARCHAR2(8) NOT NUL
          L ) TABLESPACE PSDEFAULT

          *
          ERROR at line 1:
          ORA-00959: tablespace 'PSDEFAULT' does not exist
          It seems you missed some script previously dbowner.sql. utlspace.sql creates that tablespace.
          Please be sure about the sequence of the sql scripts to run. Read carefully the Peopletools Installation Guide.

          Nicolas.