DA Morgan wrote:
> 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.

For starters, I assumed things. I apologize for that.
I assumed the OP had a user_test_data TS on one instance,
and user_prod_data on another, and wanted to copy
user_test_data over to user_prod_data.

That is not going to work; for starters, you already
have user_prod_data!
Also, there is the issue of grants on objects within
the TS - these won't be the same!

Bad choice of words, and too hasty.
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...