Re: Tablespace Question

Hi Tarek,

there is only one missing step : giving quota on that tablespace
one option is :    alter user user1 quota unlimited on db1_data ;
best regards,

Marc


"Tarek" <[EMAIL PROTECTED]> schreef in bericht
news:[EMAIL PROTECTED]
> Hi All,
>
> I am new with Oracle and I have a question regarding 'tablespace'.
>
> As System user, I created a tablespace db1_data, then I created a user
> user1, I assigned the tablespace I created as the default tablespace
> for this user.
> I grant all the priviliges to this user (creating tables, views,
> etc..)
>
> When I login with this user and try to create tables, I always get a
> 'no privilige on tablespace db1_data' error message and I can not
> create any table.
>
> I checked and I found the datafile associated with this tablespace is
> created.
>
> Is there any missing step? or is there anything wrong I did ?
>
> Thanx for help
>
> Tarek