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.
pdata.PNG (12.26 KB)