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

User_UL6AR

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

Luís Gustavo Lira

Hi,

If the problem was related to the PDATA tablespace, you must adjust the quota for this tablespaces and not for the system tablespace.

Syntax:

ALTER USER <user> quota unlimited on <tablespace name>;

In your case:

ALTER USER PEEI QUOTA UNLIMITED ON PDATA;

Also make sure you have the necessary privileges.

Gursimran S Sra

Good catch Luis.