Share 'Truncating empty temporary tables in Oracle for PeopleSoft applications'
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
sqlstatement VARCHAR2 (100);
fulltablename VARCHAR2 (40);
You can share this discussion in two ways…
Share this link:
Send it with your computer's email program: Email this