ORA-39083: Object type TABLE:”TEST”.”TEST1″ failed to create with error: ORA-01950: no privileges on tablespace ‘USERS’

When doing data pump operation with Oracle, you can get an error like below if schema to import is not authorized.This is very common error which comes due to insufficient privileges on tablespace.

ORA-39083: Object type TABLE:”TEST”.”TEST1″ failed to create with error: ORA-01950: no privileges on tablespace ‘USERS’

SQL>select USERNAME, DEFAULT_TABLESPACE from dba_users where USERNAME=’test’;

USERNAME——————————————————————————–DEFAULT_TABLESPACE
——————————
TEST
USERS

Solve the problem by authorizing the relevant user

SQL> ALTER USER test quota unlimited on users;

Have a nice day.