Re: Changing a user's default tablespace.

Oracle won't move anything for you, the objects are still where they were. If you want the objects to be moved out of the "old" default, the DBA has to move them.

April

Paul <paul_at_not.a.chance.ie> wrote in message news:<MPG.1b2e3f37c0be988c98994a_at_news1.eircom.net>...
> david.sharples3_at_ntlXworld.com says...
>
>
> > 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
>
>
> Suppose you have a user 'Billy' whose default tablespace is SYSTEM, and
> then you as dba decide to give Billy a default tablespace of FRED, and
> *_then_* you give Billy a quota of 0 on the SYSTEM tablespace, my
> question is what happens Billy's data/objects that were in SYSTEM.
>
> On giving Billy a new default tablespace, are his objects in SYSTEM
> moved, or are they still in SYSTEM? That's my question really.
>
>
> 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
Received on Mon Jun 07 2004 - 08:45:39 CDT