I have encountered the error ORA-01536 and I checked that the tablespace was only 50% used.

I have earlier grant sysdba & unlimited tablespace to user A and I revoked the sysdba role from user A a couple of days later. After that, I encountered the error ORA-01536 when trying to create a table as User A.

My question is once the dba role has been assigned then revoke, will it affect the quota assigned? I have no clue what caused the error ORA-01536 until i tried to grant unlimited tablespace to user A and everything was ok after that!

Any advices please? Thanks!