Upgrade DDLSync and UPGPhys removes function based indexes
Last updated on DECEMBER 18, 2012
Applies to:Siebel System Software - Version 188.8.131.52 SIA  and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 184.108.40.206  Com/Med
Database: Oracle 220.127.116.11
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***
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"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms