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

Changing a user's default tablespace.

From: Paul <paul_at_not.a.chance.ie>
Date: Sun, 6 Jun 2004 20:44:16 +0100
Message-ID: <MPG.1b2d846b9edbb90f989941@news1.eircom.net>

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?

TIA. 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 Sun Jun 06 2004 - 14:44:16 CDT

Original text of this message

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