not able to create table.

Hi Zeb,

the default is indeed 0, but I prefer to hard code it in this case. It shows up in dba_ts_quotas (or user_ts_quotes) so I know absolutely that people cannot create any objects in SYSTEM.

However, try this if it is defaulted :

import a user, where do the extents go ?

1. In the tablespace named in the import file, if this doesn't exist then
2. In the user's default tablespace, if this has no quota then
3. In the SYSTEM tablespace.

In your case, the SYSTEM tablespace fills up with user objects, in mine it cannot :o)

Regards,
Norman.

-----Original Message-----
From: zeb [mailto:thierry.constant1_at_free.fr] Posted At: Saturday, August 24, 2002 9:28 AM Posted To: server
Conversation: not able to create table.
Subject: Re: not able to create table.

> Then, always always always, remove any quota on SYSTEM tablespace :
>
> ALTER USER <username> QUOTA 0 ON SYSTEM;
>
> Trust me, one day you'll thank me for that !
>
> To grant space on lots of tablespace do each one as above.

Is it necessary ?
The default is QUOTA 0 on any tablespace ??? Received on Tue Aug 27 2002 - 07:56:49 CDT