My Oracle Support Banner

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 NOVEMBER 20, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
 Step 0. Backup the database.
 Step 1. Stop all Oracle Data Integrator processes
 Step 2. Connect to the Work Repository.
 Step 3. Prepare the re-initialization operation.
 Step 4. Compact and reorganize the IDs for use in the SNP_EXP_TXT/SNP_EXP_TXT_HEADER table.
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.