Great help. Appreciate the effort Mac
Ess Kay, July 27, 2018 - 1:08 pm UTC
Thanks much, Mac, for the response.
This is a follow up question. I had no other way to do so.
This step (data movement) is part of implementing TDE on Oracle 12.1. Since client wants to avoid downtime or keep it to min, I have to make sure that I find a solution to encrypt the data (tablespaces), accordingly.
Appreciate your expert input.
July 28, 2018 - 4:24 am UTC
For me - I'd move to 12.2 where it can be online with no outage.
Ess Kay, July 30, 2018 - 2:57 pm UTC
Client is not planning to move to 12.2.
Any other suggestions?
August 01, 2018 - 12:35 pm UTC
You could look at DBMS_REDEFINITION but that will be on a table by table basis.
Will REDEFINITION be ONLINE
Ess Kay, August 02, 2018 - 8:44 pm UTC
Will the database be 100% available during REDEFINITION operation?
August 20, 2018 - 3:59 am UTC
"Almost".
We take a lock at the commencement and conclusion of the operation, but not during (when all the data movement is occurring).