Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: not able to create table.
Hi,
in order to create a table you need to grant space quota on tablespace to
the user or UNLIMITED TABLESPACE system privilege. For details see ALTER
USER command.
And to eliminate such kind of question look in Oracle SQL Reference (namely
in 'Prerequisites' section in command description) before asking. So you'll
be able to get the answer more quickly and easy.
Regards,
-- Roman Mirzaitov Brainbench MVP for Oracle Administration www.brainbench.com "darkstar" <chaihock_at_singnet.com.sg> wrote in message news:ak5c52$2d7$1_at_reader01.singnet.com.sg...Received on Sat Aug 24 2002 - 03:01:15 CDT
> I encountered the following wrror when try to create a table
> ERROR at line 1: ORA-01950: no privileges on tablespace 'APP01'
>
> How can i grant the tablespace authority ? Can I assisgn multiple
tablespace
> to signle user??
>
> Thanks..
>
>
>