How do I migrate the content from clear text application tablespaces to encrypted tablespaces?
• Extract the DDL that was used to create the original application tablespaces using ‘dbms_metadata.get_ddl’ and save the output as a SQL script. • Add ‘ENCRYPTION DEFAULT STORAGE(ENCRYPT)’ to each ‘create tablespace’ statement (the SIZE parameter does not need to be changed, since TDE tablespace encryption does not increase storage requirements). • Export either the whole database, or the schema that owns the application tablespaces, with Data Pump (expdp). • Drop the application tablespaces ‘with contents and datafiles’. • Run the SQL script to create encrypted application tablespace with otherwise unchanged characteristics. • Import the dumpfile with Data Pump (impdp).
