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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I create a table in a tablespace?

Re: How can I create a table in a tablespace?

From: Alex Hudghton <alex_at_alenda.freeserve.co.uk>
Date: Wed, 8 Sep 1999 14:13:52 +0100
Message-ID: <7r5nem$8fu$1@taliesin.netcom.net.uk>

Ralf Boroschewski <ralf_at_transmedia.de> wrote in message news:37D66AF3.E8A0B5CC_at_transmedia.de...
> Hallo,
>
> I executed
>
> GRANT CREATE TABLE TO <user name>;
> ALTER USER <user name> quota UNLIMITED on <tablespace name>;
>
> both lines terminated successfully. I also used the "Oracle Security
> Manager" to grant all the privileges which that program offers, except
> SYSDBA and SYSOPER (granting this fails). After doing all that stuff
> creating a table whithin my specified tablename still fails.
>
> What else can I do??
>

Check the tablespace isn't read only ?

Alex Received on Wed Sep 08 1999 - 08:13:52 CDT

Original text of this message

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