myPeopleSoft
PeopleSoft Community Network
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);
t_count NUMBER;
CURSOR c1
IS
SELECT owner || '.' || table_name
FROM all_tables a
PeopleSoft Jobs in US
Groups
© 2024 Created by Maisam Agha.
Powered by
