Re: How can I create a table in a tablespace?

From: Clemens Hoffmann <choffmann_at_steinmayr.de>
Date: Wed, 8 Sep 1999 08:37:18 +0200
Message-ID: <7r503b$cfu$1@newsread.f.de.uu.net>

In article <37D50B6B.C22C82F0_at_transmedia.de>, Ralf Boroschewski <ralf_at_transmedia.de> wrote:

> I created a tablespace, but when I wonna create a table in that
> tablespace, always an error 1950 (no privileges on tablespace "name")
> occurs.
> This also happens when I'm SYSDBA and Administrator (WinNT). I have no
> idea anymore. What can I do?
>

Have you given quotas to the use on this tablespace ?

ALTER USER <user name> quota UNLIMITED on <tablespace name>

Greetings

Clemens Hoffmann Received on Wed Sep 08 1999 - 01:37:18 CDT