Re: Quickest Way To Recreate a Database
- From: Michael Wehrle <michaelw436@xxxxxxxxx>
- To: Mathias Magnusson <mathias.magnusson@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 30 Jun 2009 16:45:15 -0400
Mathias, Oracle explains what this ghost data is here...
http://www.oracle.com/technology/deploy/security/database-security/transparent-data-encryption/tde_faq.html#A15032
Also at that link Oracle's recommendation is to do as you recommended in
theory. New TS, Move Segments into new TS, drop old TS. We are looking at
the best way to accomplish that with minimal downtime. We have talked about
the possibility of exp/imp, doing exactly as Oracle described above, maybe
use Streams, anything is a possibility here if it will save downtime.
Other related posts:
