My Oracle Support Banner

How To Cleanup S_LST_OF_VAL Table Thoroughly After Repository Deletion With Orphan Records? (Doc ID 2707831.1)

Last updated on SEPTEMBER 08, 2020

Applies to:

Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.

Goal

Customer was on IP2017 and later version and were looking for a way to cleanup S_LST_OF_VAL tables for previously deleted repositories. They recently noticed that the we were running repository cleanup using below command:

RRCleanup.exe -t "tableowner" -u "user" -p "xxxx" -r "repositoryname" -o "ODBC_DSN name" -s "$SIEBEL_ROOT\siebel\ses\siebsrvr" -b "B"

The above command is deleting the repository successfully however the S_LST_OF_VAL records are not cleaned up. How can we cleanup the S_LST_OF_VAL records thoroughly?
 

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
References


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