Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Changing a user's default tablespace.
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.comReceived on Sun Jun 06 2004 - 14:44:16 CDT