Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to copy a tablespace?
frank.van.bortel_at_gmail.com wrote:
> Look at transportable tablespaces - yet you cannot rename them.
Perhaps I have misunderstood your intent in saying this but:
ALTER TABLESPACE users RENAME TO user_data;
Works just fine in 10gR2.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Thu Mar 30 2006 - 10:58:27 CST