How to check what quota I have?

Every application developer has the query in mind that how much quota I have on which tablespace. Using following query you can find out your quota on the tablespace.

SQL> SELECT * FROM user_ts_quotas;

Table USER_TS_QUOTAS contains following columns

   TABLESPACE_NAME

      Tablespace name

   BYTES

      Number of bytes charged to the user

   MAX_BYTES

      User's quota in bytes. NULL if no limit

   BLOCKS

      Number of ORACLE blocks charged to the user

   MAX_BLOCKS

      User's quota in ORACLE blocks. NULL if no limit

It means you can get how much bytes used by you from max_bytes-bytes. If you found -1 in result then don’t confuse it means you have UNLIMITED quota on the said tablespace.