Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to copy a tablespace?
DA Morgan wrote:
> frank.van.bortel_at_gmail.com wrote:
>
>> Look at transportable tablespaces - yet you cannot rename them.
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