Hi Mark,
Thanks, I found it. Now I am trying to convince the customer to turn off
TDE and decrypt stuff before the migration. I believe that the only
alternative is expdp/imdp, but would try to avoid that at all costs,
because it will take a few minutes with 7TB database.
Regards
On 12/01/2016 02:30 PM, Powell, Mark wrote:
Malden, see Doc ID 1454872.1 Transportable Tablespace (TTS) Restrictions and Limitations: Details, Reference, and Version Where Applicable which states that tablespaces which contain encrypted columns cannot be transported and that TTS of TDE tablespaces is not supported on 12c.
------------------------------------------------------------------------
*From:* oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf of Mladen Gogala <gogala.mladen@xxxxxxxxx>
*Sent:* Thursday, December 1, 2016 2:18:14 PM
*To:* RajeevGM
*Cc:* oracle-l
*Subject:* Re: Transportable tablespaces and TDE
On 12/01/2016 02:14 PM, RajeevGM wrote:
> Malden,
>
> Have you already reviewed 1166564.1 ?
>
> Rajeev
Thanks Rajeev, this is precisely what I needed. I owe you one.
Regards.
>
>> On Dec 1, 2016, at 1:58 PM, Mladen Gogala <gogala.mladen@xxxxxxxxx> wrote:
>>
>> I have a client who would like to have several databases moved from 11.2.0.4 on Solaris to 12.1.0.2 on Linux. There was nothing problematic in the task until I discovered that the source databases are using TDE (transparent data encryption). The tablespaces containing data are all encrypted. I have never worked with TDE before and I am not sure that transportable tablespaces are even an option here. Does anyone have any documentation or experience with this? I would be deeply grateful for any help.
>>
>> TIA
>>
>>
>> --
>> Mladen Gogala
>> Oracle DBA
>> Tel: (347) 321-1217
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
--
//www.freelists.org/webpage/oracle-l
