Re: My first table creation

On Tue, 03 Aug 1999 17:16:53 +0200, Guillaume BRIALON <guillaume.brialon_at_synlog.com> 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.
>

alter user xxxx default tablespace usr temporary tablespace temporary

(if you have installed a default database, that is)

• terje