Re: Problem creating table with new account

You don't seem to have quota for the system tablespace. This is perfectly OK, as it is considered very bad practice to create user objects in the system tablespace other than objects directly created by Oracle products. Creating your own tables will definitely result in a) fragmentation of the system tablespace b) competition for resources in the tablespace.

In short: you are advised to create your own tablespace for your own objects, a default install has the tablespace USER_DATA for this purpose. To avoid creating objects in the system tablespace you should use the command
alter user <username> default tablespace user_data (or whatever tablespace you designate for this purpose).

Hth,

Sybrand Bakker, Oracle DBA

"root" <root_at_localhost.localdomain> wrote in message news:966699582.732057749_at_news.rete039.it...
> Hello all,
>
> I have created a new account in a Oracle 8.5.0 DB giving all privileges
 for
> creating tables.
> When I logon and execute the CREATE TABLE command I get the error message
> saying that I don't have privileges on SYSTEM tablespace.
> What is the problem ?
> Thanks a lot.
>
> Marco Mapelli
Received on Sun Aug 20 2000 - 14:52:12 CDT