Re: Changing a user's default tablespace.

From: anacedent <anacedent_at_hotmail.com>
Date: Sun, 06 Jun 2004 12:51:49 -0700
Message-ID: <qBKwc.51096$oi5.32736@fed1read07>

Paul wrote:

> Hi all,
>
>
> I am working my way through "Beginning Oracle Programming" by Dillon,
> Beck, Kyte & al.
>
> 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 Received on Sun Jun 06 2004 - 14:51:49 CDT