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: Changing a user's default tablespace.

Re: Changing a user's default tablespace.

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Mon, 7 Jun 2004 00:02:51 +0100
Message-ID: <_gOwc.515$Ki4.419@newsfe2-gui.server.ntli.net>

"Paul" <paul_at_not.a.chance.ie> wrote in message news:MPG.1b2da5ac5e2e4ba9989946_at_news1.eircom.net...
>
>
> anacedent_at_hotmail.com says...
>
>
> > > Now, they have an example where you change a user's default
tablespace.
> > > My question is what happens to the objects that the user already has
in
> > > the (now) non-default tablespace? Do they get moved automatically, or
is
> > > this something that the dba has to take care of manually?
>
> > Nothing happens at all.
> > The value of the "default tablespace" is used to "decide"
> > into which tablespace an object will be created if the
> > CREATE command does not include the "TABLESPACE <NAME>" clause
>
>
> Suppose that previously the tablespace was SYSTEM and you issue (as dba)
> a quota of 0 on that tablespace for the user? My question I suppose is
> "what happens then?".
>
> You could probably turn around and say to me, "well, try it and see",
> but my problem there is that I don't want to mess with the samples too
> much (i.e. destroy some important data/structures) since the book relies
> on these for many of its examples.
>
>
> Thanks for your input.
>
>
> Paul...
>
>
> --
> plinehan y_a_h_o_o and d_o_t com
> C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
> Please do not top-post.
>
> "XML avoids the fundamental question of what we should do,
> by focusing entirely on how we should do it."
>
> quote from http://www.metatorial.com

if you change quota to 0 on that tablespace then you will get an error when you try to create any object - however if you have dba rights then it will work as you have the 'unlimited tablespace' privelege Received on Sun Jun 06 2004 - 18:02:51 CDT

Original text of this message

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