Converting Descending Indexes
As of PeopleTools release 8.54, to optimize performance, descending indexes are no longer supported. If you are upgrading from an earlier version of PeopleTools, you must convert any descending indexes to ascending indexes by dropping descending indexes and recreating them as ascending indexes.
The following scripts are provided in <PS_HOME>\SCRIPTS\ORA\ to accomplish this task:
postupgcreatedescindexes.sql
postupgdropdescindexes.sql
To convert descending indexes to ascending indexes, complete these steps:
Connect as AccessId, run postupgdropdescindexes.sql
Connect as AccessId, run postupgcreatedescindexes.sql
Connect as AccessId, run psdropdescindexes.sql
Connect as SYSDBA and run alter system set "_ignore_desc_in_index"=true;
Connect as AccessId, run pscreatedescindexes.sql
Connect as SYSDBA and run alter system set "_ignore_desc_in_index"=false;