I am trying to insert data from prod to dev by using TPT Update operator. By mistake i have deleted all error tables including work table, log table.
Agin when i submit the script am got TPT10508: RDBMS error 2583 error in teradata tpt Error. Can you please suggest me how resolve this issue.
UPDATE_OPERATOR: preparing target table(s)
UPDATE_OPERATOR: TPT10508: RDBMS error 2583: Worktable is missing for ISH_FEDXFGT_L1F5_DB.fxf_ship_rev_credit_comp during MLoad restart.
UPDATE_OPERATOR: disconnecting sessions
You will not be able to restart, complete, or back out the update at this point.
You can use the RELEASE MLOAD statement to remove the lock, see the MultiLoad manual for details.
Or drop and recreate / recover the target table.