You can use any valid combination of producer and consumer operators to create a job script that moves data within the database environment. However, the following section provides examples of some of the most common job scenarios. Evaluate the examples and, if possible, use one of the associated sample job scripts before creating your own.
- Job Example 19: Export Data from a Table and Load It into an Empty Table
- Job Example 20: Export Data and then Use It to Perform Conditional Updates Against Production Tables
- Job Example 21: Bulk Delete of Data from the Database
- Job Example 22: Export BLOB/CLOB/JSON Data from One Database Table to Another