QUOTA ON

How to Resolve ORA-01536: space quota exceeded for tablespace

by Ed Chen
November 10, 2022June 6, 2023

ORA-01536 Tried to use CTAS to make a table in a tablespace, but it failed with ORA-01536. SQL> create table t1 tablespace users as select… Read More »

How to Resolve ORA-00922: missing or invalid option

by Ed Chen
November 9, 2022March 24, 2023

ORA-00922 ORA-00922 means that SQL parser found an invalid option where should be empty or one of other valid options it expects. Since it's a… Read More »

Revoke Quota Unlimited on Tablespace from User

by Ed Chen
July 10, 2022April 24, 2023

Revoke Tablespace Quota In previous post, we have talked about how to set quota on tablespace for users. Now, let's see how to revert it.… Read More »

Grant Quota Unlimited on Tablespace to User

by Ed Chen
July 10, 2022June 6, 2023

Grant Tablespace Quota Since quota usage limitation is not an object privilege, we can't grant it like this: SQL> grant quota 100g on erpapp_tbs_01 to… Read More »

JavaScript is not enabled. Please enable it and reload the page.