View Single Post

   
  #3 (permalink)  
Old 04-08-2008, 10:07 AM
DA Morgan
 
Posts: n/a
Default Re: How to copy a tablespace?

frank.van.bortel@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@x.washington.edu
(replace x with u to respond)
Reply With Quote