Re: Space quota exceeded Error

Hi,

• The Tablespaces are not belonged anybody. So, it's no owner for TS.
• You can regulate Quotas for user against any tablespace. alter user SCOTT quota 0 on SYSTEM quota 10M on TEMPORARY_DATA quota unlimited on USER_DATA ;

Mark

Gaetano Gallo <gg_at_omnilink.net> wrote in message news:3783106A.363254AC_at_omnilink.net...
> I use Oracle 7.3.4 on Windows NT
>
> When i try to create some new tables in a tablespace, logged in as the
> owner of the tablespace, i get the Error-Message "ORA-01536: space quota
> exceeded for tablespace ...". But the owner does not have any quota
> limitations. The Storage Manager shows, that the tablespace is used only
> for 30% and has still 70% of empty space. I tried to restart the DB
> Server but without any result. Further i took the tablespace offline and
> later online again. The problem still exists.
>
> May someone help me ? Thx
>
Received on Wed Jul 07 1999 - 05:46:03 CDT