Upgrade DDLSync and UPGPhys removes function based indexes

(Doc ID 530041.1)

Last updated on DECEMBER 18, 2012

Applies to:

Siebel System Software - Version 7.8.2.3 SIA [19221] and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.8.2.3 [19221] Com/Med
Database: Oracle 9.2.0.6
Application Server OS: Sun Solaris 9
Database Server OS: Sun Solaris 8

This document was previously published as Siebel SR 38-3162047295.
***Checked for relevance on 18-Dec-2012***



Symptoms

We have uncovered during the 78 upgphys the ddlimp process removes all standard provided function based indexes (FBI). And the only way to get these FBIs back we have perform an apply on all tables thru Siebel tools.
This is can be reproduced by running a ddlsync using the database server configuration utility on any Oracle database that contain FBIs.
Use the following SQL to determine that FBIs exist in database. "
select index_name from user_indexes where index_type LIKE 'FUNCTION%';

We believe there are approx. 244 FBIs provided OOTB.
Execute ddlsync process and rerun the query above and it should return no rows.

We confirm that the logical schema does maintain the proper definition for "descending" sort order for indexed columns but at the database level after the ddlsync these "descending" indexes become "ascending"

Cause

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