Disadvantage of DAC 11g patch feature and the resolution

Hi All,

 In my previous post DAC 11g code migration, we have discussed about how to perform patch migration(or subset code migration). 

 But I faced this issue later sometime with the patch migration.

Traditional Container Migration is taking longer time.

To get rid of this issue, I followed this method.

Taken the tables backup which involves in DAC PATCHING and truncated them.

CREATE TABLE W_ETL_PATCH_BKP AS select * from W_ETL_PATCH;CREATE TABLE W_ETL_PATCH_DATA_BKP AS select * from W_ETL_PATCH_DATA;CREATE TABLE W_ETL_PATCH_CHILD_BKP AS select * from W_ETL_PATCH_CHILD;CREATE TABLE W_ETL_PATCH_AUDIT_BKP AS select * from W_ETL_PATCH_AUDIT;CREATE TABLE W_ETL_APATCH_BKP AS select * from W_ETL_APATCH;

TRUNCATE TABLE W_ETL_PATCH;TRUNCATE TABLE W_ETL_PATCH_DATA;TRUNCATE TABLE W_ETL_PATCH_CHILD;TRUNCATE TABLE W_ETL_PATCH_AUDIT;TRUNCATE TABLE W_ETL_APATCH;

Note:- But take this approach on your own decision.