Groovy DBA

 >sqlplus schema_name/password SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 7 14:52:44 2021 Copyright (c) 1982, 2014, Oracle.  All rights reserved. Last Successful login time: Tue Dec 07 2021 14:52:41 -06:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production SQL> purge recyclebin; Recyclebin purged.

 SELECT MIN(D_TIMESTAMP) FROM drmadmin.RM_TRANSACTION_HISTORY;

  To check table's status ('C' means that the table is in set integrity pending) db2 "select status from syscat.tables where tabname = 'COLLDESC'" To set integrity db2 "set integrity for wcs.colldesc immediate checked"