PeopleSoft tools provides complete exposure to technical PeopleSoft tools and tips to help with PeopleSoft configuration and techniques – providing knowledge base answers.
Truncating temporary tables is an effective way of resetting the high-watermark level in Oracle databases.
The following script just truncates those tables that are empty, as sometimes temporary tables containing data should not be deleted as the data may belong to processes in error.
Peoplesoft Tools
150 members
Description
PeopleSoft tools provides complete exposure to technical PeopleSoft tools and tips to help with PeopleSoft configuration and techniques – providing knowledge base answers.
Truncating empty temporary tables in Oracle for PeopleSoft applications
by Michale Johannsen
Jul 22, 2014
Truncating temporary tables is an effective way of resetting the high-watermark level in Oracle databases.
The following script just truncates those tables that are empty, as sometimes temporary tables containing data should not be deleted as the data may belong to processes in error.
DECLARE