Campus Solutions - PSFT (MOSC)

MOSC Banner

cleanup old CS data

edited Oct 18, 2016 1:35PM in Campus Solutions - PSFT (MOSC) 7 commentsAnswered

Anyone has any script to delete the OLD CS unwanted or log data from the database, like below,  so we can save some space on DB side and gain performance .

Thank you.

DELETE FROM PS_CALC_MESSAGES WHERE STRM <2078

DELETE FROM PS_SA_REPORT_RSLT  WHERE REPORT_REQUEST_NBR < '000275500'

DELETE FROM PS_FORM_DATA_C128  FROM PS_FORM_INSTANCES a,PS_FORM_DATA_C128 b  WHERE a.FORM_PROC_INST = b.FORM_PROC_INST AND a.EXPIRATION_DATE < '2007-01-01' ;

DELETE FROM PS_FORM_DATA_C254 FROM PS_FORM_INSTANCES a,PS_FORM_DATA_C254 b  WHERE a

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

PSFT Campus Solutions Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center