HCC compression issue

Hello expert,

                     I am doing some research on HCC where I am using sun ZFS storage with 11.2.0.4 oracle database.My approach is like below.

1. Identified an partitioned table which is range partitioned by date column and sub partitioned by a raw column.

2. Extracted DDL for that table

3. Modified script such that any partition beyond 2 years are compressed with archive high and within 2 years it is compressed with query low.Modify the table name with bkp as a prefix and create table structure in db.

4. Now load data from actual table into this new table using append hint like below

SQL> insert into /*+ APPEND */ ITRONADM.BKP_DEVICEEVENT select * from ITRONADM.DEVICEEVENT;