I am trying to restore the table using the COPY command . The table is not present in the target database. I am creating the new table using the ARCHIVE done using the PPI condition. The ARCH file has only one month data present in it. I am getting an error for Target_Table does not exist.
COPY DATA TABLE (target_database) (FROM (destination database),REPLACE CREATOR, EXCLUDE TABLE(dest_table1)), (DBA.target_table_NEW) (FROM (dest_db.dest_table1), REPLACE CREATOR, PARTITIONS WHERE (! DBA.target_table_NEW.SNT_DT BETWEEN DATE'2008-01-01' AND DATE'2008-01-31' !) ), RELEASE LOCK ,FILE=ARCHIVE ;