How To Renumber The Records In The ODI 10g and 11g SNP_EXP_TXT/SNP_EXP_TXT_HEADER Work Repository Table

(Doc ID 753313.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Data Integrator - Version 10.1.3.2.0 to 11.1.1.9.99 [Release 10gR3 to 11gR1]
Information in this document applies to any platform.

Goal

This document provides detailed SQL commands and step-by-step operations in order to:

I M P O R T A N T:

1. The SQL commands below should not be applied as stand alone, but only within the flow described in <Note 603109.1>.

2. Due to the size increase of execution-related Columns, the SQL commands below are less relevant with versions 11g of ODI (it is very improbable you have reached the authorized upper limit of 19 digits...).

3. The solution below has been finalized and fully tested only for Oracle, Microsoft SQLServer, IBM DB2/400 and IBM DB2 UDB.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms