Le souci
J’utilise la commande purge d’adrci mais mes problèmes restent présents
La commande
adrci> delete from PROBLEM
L’autre souci
L’autre souci c’est que ça purge tous les problèmes et que j’aimerais bien garder ceux qui sont “récents”.
C’est pas interdit de demander de l’aide …
adrci> help delete
Usage: DELETE FROM <relation> [WHERE <predicate_string>]
Arguments:
<relation_name>: Name of the relation to delete from.
[WHERE <predicate_string>]: The predicate string must be double-quoted.
Examples:
delete from incident where 'incident_id > 1'
adrci> show problems
ADR Home = /opt/oracle/diag/rdbms/dbun/DBNAME:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1 ORA 600 [psdnopGetACL-4] 81105 2016-03-27 03:53:10.648000 +02:00
2 ORA 600 [ktcccod-1] 3960130 2016-04-22 06:25:53.408000 +02:00
3 ORA 600 [kdBlkCheckError] 8600040 2016-05-24 11:14:17.489000 +02:00
Allons-y essayons
adrci> delete from PROBLEM where lastinc_time < to_date('2016-03-27 04:00:00', 'YYY-MM-DD HH24:MI:SS' )
DIA-48260: Function to_date not found
Mince, c’est pas du vrais SQL Oracle avec les fonctions qui vont bien !
adrci> delete from PROBLEM where lastinc_time < sysdate-60 DIA-48230: Expression arguments must match types DIA-48249: Type mismatch - lhs = 7, rhs = 6, result = 8, op = 0
Mince, ça ne sait pas transtyper !
adrci> delete from PROBLEM where lastinc_time < systimestamp - 60 1 Row Deleted adrci> show problems ADR Home = /opt/oracle/diag/rdbms/dbun/DBNAME: ************************************************************************* PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME -------------------- ----------------------------------------------------------- -------------------- ---------------------------------------- 2 ORA 600 [ktcccod-1] 3960130 2016-04-22 06:25:53.408000 +02:00 3 ORA 600 [kdBlkCheckError] 8600040 2016-05-24 11:14:17.489000 +02:00 2 rows fetched
C’était pourtant pas si compliqué