Determine DATABridge Client data table status when Clone fails after hours of record transfer.

Technical Note 1.0.12172784.3593764
Created 14-Feb-2002

Applies To
DATABridge Client

Oracle

Symptoms

Error:  ORA 2356 Out of space

Error:  ORA 1653 Unable to extend table

Failure occurs during Clone

Goal

Determine DATABridge Client data table status when Clone fails after hours of record transfer.

Cause

Oracle administrator supplies more space, but what is our status?  Do we have to start the clone over?

Fix

All data sets that were successfully extracted do not need to be recloned. This situation should be recoverable except for the tables that were being loaded when the problem occurred.  The ds_mode should be non-zero on all Cloned tables.  The ds_mode = 0 for the tables that were being loaded during the failure and those not started yet.  The next Process command will only Clone the tables where ds_mode = 0.