If the Auto Execute Drop/Reload check box is not selected on the Configure RPS Node dialog and a Drop/Reload script is required, an administrative user must intervene to apply the table redefinitions, repopulate, and restart the Datapump application.
When the RPS node reconnects to the target database, RPS verifies table consistency before continuing.
An expert database administrator may be able to accomplish the required changes in-place, avoiding the need to completely reload the table. In cases where an administrative user must drop the affected tables and reload them, the generated script can be run and the Extract & Load command from the Extracts menu in the Jade RPS Manager window can be used for selected tables to manually apply the required changes.
To reload a table by executing the manual alter script generated by RPS directly without alteration, use the RPS Manager application, as follows.
If you accept the default table replacement strategy, execute the generated alter script to rename the original table and create a new empty table.
Extract objects for selected tables from the primary database (for the Working Set mode) or the RPS database (for the Full or Mapped Extent mode), using the RPS Manager application. For details, see "Extracting Data from the JADE Database" or "Extracting Data and Loading it into the Relational Database", later in this chapter.
Execute the generated bulk insert script (the bulkInsert.sql file) to load the extracted data. For details, see "Executing an SQL Script", "Extracting Data and Loading it into the Relational Database", or "Loading Extracted Data into the Relational Database", later in this chapter.
Use the Extract & Load command from the Extracts menu in the RPS Manager application to execute the generated bulk insert script and to perform an extract and load as a single action. For details, see "Extracting Data and Loading it into the Relational Database", later in this chapter.