Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: tablespaces
Steve Ashmore wrote:
> 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.. =-
> >
Also, learn the syntax for creating locally managed tablespaces with uniform extents. I hate to think what a mess your, above, create tablespace command is making.
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri May 09 2003 - 08:25:50 CDT