Re: My first table creation

You should never, ever create tables in the SYSTEM tablespace. What you should do is create a tablespace for your application tabels and then set that tablespace as the default tablespace for the user that you created.

Guillaume BRIALON wrote:

> Hi, I am a f..... newbie.
> I've just installed Oracle8 on Linux.
> I created a user and granted him "create session" and "create table".
> The following demonstrates my problem :
>
> SQL> create table junk(num int, name char(20));
> create table junk(num int, name char(20))
> *
> ERROR at line 1:
> ORA-01950: no privileges on tablespace 'SYSTEM'
>
> What could I do to fix this?
>
> Thx,
> Guillaume.
Received on Tue Aug 03 1999 - 12:05:40 CDT