Re: My first table creation

Hi,

    First, really shouldn't create tables in SYS.

    Start up sqlplus and see what tablespaces you have:

        SELECT TABLESPACE_NAME FROM DBA_TABLESPACES;     You should find something like user or usr or user_tablespace (I forget which). Let's assume that you find usr.

        CREATE USER newbie IDENTIFIED BY <password>
        DEFAULT TABLESPACE usr
        TEMPORARY TABLESPACE temporary
        UNLIMITED QUOTA ON usr;

        GRANT CONNECT TO newbie;
        GRANT RESOURCE TO newbie;

If you want to create newbie with the exalted status of DBA substitute the following for the last two SQL statements above:

        GRANT CONNECT TO newbie WITH ADMIN OPTION;
        GRANT RESOURCE TO newbie WITH ADMIN OPTION;
        GRANT DBA TO newbie WITH ADMIN OPTION;
        GRANT EXP_FULL_DATABASE TO newbie WITH ADMIN OPTION;
        GRANT IMP_FULL_DATABASE TO newbie WITH ADMIN OPTION;

Regards
Jerry Gitomer

Guillaume BRIALON wrote in message
<37A707E5.86A4CC4C_at_synlog.com>...
>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 Wed Aug 04 1999 - 08:03:21 CDT