Re: tablespaces

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Fri, 9 May 2003 05:29:50 -0500
Message-ID: <vbn0ovbe75um2a@corp.supernews.com>

Try

alter user my_user quota unlimited on tempops;

or
grant unlimited tablespace to my_user;

The first is the more perferred method.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"Michael L. Hostbaek" <carlos_at_pez.dk> wrote in message news:slrnbbms30.3dk.carlos_at_freebsdcluster.dk...
> Hello,
>
> I have created a new tablespace, like this:
> create tablespace tempops
> datafile '/oracle/oradata/ITXC/tempops01.dbf'
> size 150M
> autoextend on next 50M
> maxsize 450M;
>
> I created it as 'my_user' after initiating a
> 'grant create tablespace to my_user'
>
> However, when doing a 'select * from user_tablespaces' I am not able to
> see the newly created tablespace ? What have I forgotten ?
>
> Thanks.
>
> /mich
>
>
> --
> Regards,
> Michael L. Hostbaek
> -= So long, and thanks for all the fish.. =-
>
Received on Fri May 09 2003 - 05:29:50 CDT