Forum Stats

  • 3,840,394 Users
  • 2,262,599 Discussions
  • 7,901,262 Comments

Discussions

ERROR: ORACLE execute error: ORA-01950: no privileges on tablespace 'PDATA'

User_UL6AR
User_UL6AR Member Posts: 14 Green Ribbon

Dear Oracle community,

Sorry to bother you again. I know that this question was already asked, but even I made efforts I'm not able to solve this issue. I have a table PEEI_SYS.PEEI_P_TRACKING that is created in PDATA tablespace. Even after I made ALTER USER PEEI QUOTA UNLIMITED ON SYSTEM, the user PEEI cannot insert rows in the table PEEI_SYS.PEEI_P_TRACKING. Could you please help me ? The error I have is:

ERROR: ERROR: ERROR: ERROR: ORACLE execute error: ORA-01950: no privileges on tablespace 'PDATA'.    With the occurrence of the 

    above ERROR, the error limit of 1 set by the ERRLIMIT= option has been reached. ROLLBACK has been issued(Any Rows processed 

    after the last COMMIT are lost).    Total rows processed: 1    Rows failed     : 1 

  ROLLBACK has been issued(Any Rows processed after the last COMMIT are lost).

Thank you in advance.


Answers