E-INST: Indexes Reappear in Alter Audit PT 8.48+
Last updated on JULY 18, 2016
Applies to:PeopleSoft Enterprise PT PeopleTools - Version: 8.4
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 201070468
"""""reviewed for currency Feb 2010"""""
After a new demo installation of PeopleTools 8.48, whenever an alter audit is run, most (or all) of the indexes appear to show up again and again. Below is an example of what is showing up:
DROP INDEX PS_AE_SECTION_TBL
CREATE UNIQUE INDEX PS_AE_SECTION_TBL ON PS_AE_SECTION_TBL
EFFDT DESC) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000
MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING
ALTER INDEX PS_AE_SECTION_TBL NOPARALLEL LOGGING
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