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:
- Renumber the values of ODI 10g / 11g SNP_EXP_TXT/SNP_EXP_TXT_HEADER and referencing tables, and
- Compact the ODI 10g / 11g ID sequence which will be re-initialized with a starting value of 1.
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.
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 |