Re: ora-01950: no privileges on tablespace

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Sat, 23 Mar 2002 11:44:00 +1100
Message-ID: <a7gj64$gb7$1@lust.ihug.co.nz>

alter user blah quota 100M on tablespace users;

or
(and this is what I invariably do, because even though Developers cause DBAs grief, we are part of the one team)

alter user blah quota unlimited on tablespace users;

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Jeff Y. Y." <yuanjeff_at_yahoo.com> wrote in message
news:a2bc9497.0203221613.13f08246_at_posting.google.com...


> I just installed Oracle 8.1.7 on NT. When I tried to create a table in

> an account, I got "ora-01950: no privileges on tablespace 'users'".

>

> How can I fix the problem?

>

> Thank you very much.

Received on Fri Mar 22 2002 - 18:44:00 CST