Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: not able to create table.

Re: not able to create table.

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Sat, 24 Aug 2002 14:01:15 +0600
Message-ID: <ak7eg5$1gobmn$1@ID-127142.news.dfncis.de>


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...

> 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..
>
>
>
Received on Sat Aug 24 2002 - 03:01:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US