Oracle DBA, How To, Error, Cause and Action

ORA-01568: cannot set space quota on PUBLIC

ORA-01568: cannot set space quota on PUBLIC




Cause: Trying to set space quota on a tablespace for PUBLIC.




Action: If trying to grant system-wide or tablespace-wide space priviledges to all users, use GRANT RESOURCE [ON ] TO PUBLIC.