If a table does not exist, execute the following script:

COPY FROM <source_user_name>/<source_pwd>@<source_tnsname> TO <target_user_name>/<target_pwd>@<target_tnsname> CREATE PR_DATA_IH_FACT USING SELECT * FROM PR_DATA_IH_FACT;

If a table exists with the exact same columns:

1. Make sure there are no primary key (PK) constraints on the PXFACTID column in the destination database and do not move any constraints.

2. Execute the following script:

   COPY FROM <source_user_name>/<source_pwd>@<source_tnsname> TO <target_user_name>/<target_pwd>@<target_tnsname> INSERT PR_DATA_IH_FACT USING SELECT * FROM PR_DATA_IH_FACT;