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: tablespaces

Re: tablespaces

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Fri, 09 May 2003 06:25:50 -0700
Message-ID: <3EBBAC5E.FFE75D41@exxesolutions.com>


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

Original text of this message

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