ORA-01536: space quota exceeded for tablespace
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!