Re: How to copy a tablespace?

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 30 Mar 2006 20:22:56 +0200
Message-ID: <e0h6s9$ikb$1@news1.zwoll1.ov.home.nl>

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

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...

Received on Thu Mar 30 2006 - 12:22:56 CST