Re: My first table creation

the other post is right, stay away from system....

create a tablespace USER_DATA....

when you set up your user, create like this:

create user NEWUSER identified by NEWPASSWORD default tablespace USER_DATA
etc etc

grant .... to NEWUSER

Brent

>
>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'
Received on Tue Aug 03 1999 - 15:32:06 CDT