How to fix the Oracle error ORA-01568: cannot set space quota on PUBLIC?

In this post, you’ll learn more about the Oracle ErrorORA-01568: cannot set space quota on PUBLIC with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01568: cannot set space quota on PUBLIC

Reason for the Error ORA-01568: cannot set space quota on PUBLIC

Trying to set space quota on a tablespace for PUBLIC.

How to fix the Error ORA-01568: cannot set space quota on PUBLIC ?

You can fix this error in Oracle by following the below steps

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