// Oracle error reference

ORA-01950: no privileges on tablespace

The user has no space quota on the tablespace where it is trying to create or grow a table or index. Grant a quota.

Error code
ORA-01950
Category
Space, memory and limits
Error message
no privileges on tablespace 'string'

What it means

Creating segments (tables, indexes, LOBs) uses space in a tablespace, and users need a quota there. ORA-01950 means the owner of the object has no quota, or none left, on that tablespace. Since 12c the RESOURCE role no longer grants UNLIMITED TABLESPACE, which is why new users often hit this on their first insert.

Newer releases word it as The user user_name has insufficient quota on tablespace tablespace_name.

Common causes

  • A new user with no quota on its default tablespace.
  • A quota that was set and has been used up.
  • Creating an object in a tablespace other than the user's default one.

How to fix it

  1. Grant a quota on the tablespace (an administrator runs this).

    ALTER USER app_user QUOTA 10G ON users;
    -- or
    ALTER USER app_user QUOTA UNLIMITED ON users;
  2. Check current quotas.

    SELECT tablespace_name, bytes, max_bytes FROM dba_ts_quotas WHERE username = 'APP_USER';

Related errors

More space, memory and limits errors

The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.

// fewer errors, faster fixes

Work on Oracle in SQLly

A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for Oracle and the other databases you use.