PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

How to know a table is temporary table that statistics must not be gathered -Using Peoplesoft Applic

edited Jul 22, 2013 12:42PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 6 commentsAnswered
Hi experts.
How to know a table is temporary in PEoplesoft Application 8.47.14 and so, statistics must not be gathered -Using Peoplesoft Application 8.47.14

I have the following script to exclude "temporary tables" , but I don't know if a table can be a temporary table and not have this name:

 

and table_name not like '%TAO%' and table_name not like '%TMP%' and table_name not like '%TEMP%' and table_name not like '%BIN%' and table_name not like '%T30%' and table_name not like '%T31%' and table_name not like '%T32%' and table_name not like '%T33%' and table_name not like '%T34%' and table_name not like '%T35%' and table_name not like '%T36%' and table_name not like '%T37%';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center