To drop all of the target tables in the task, reset a relational target table in a replication task.
You might want to drop a target table when you want to re-create it based on the latest source object definition. When you reset target tables for a replication task, the task performs the following actions:
1Drops all of the target tables included in the replication task from the database.
2Sets the load type for the replication task to full load.
After you run the replication task to reset the target, you must run the replication task again to reload the data from all source objects included in the task. When you run the replication task after you reset the target, the replication task recreates each target table. The replication task then loads all of the data into the new table.
If the target table is damaged, the replication task might consistently fail to write to the target table. You might need to reset the relational target.
Resetting a target table
You can reset the relational target tables included in a replication task.
1On the Explore page, navigate to the replication task.
2In the row that contains the task, click Actions and select Reset Target.
Rules and guidelines for resetting a target table
Use the following rules and guidelines when you reset a target table:
•If you previously created indexes on a target table and reset the target table, the replication task drops the indexes and the target table. You must create the indexes again.
•If you try to reset a target table that does not exist in the target database, an error appears.
•The replication task drops the target table that was updated the last time the task ran. For example, if you change the prefix of the target table and do not run the replication task, the replication task resets the old target table.