sip_script_limpeza_oracle.sql 462 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 
/*
SCRIPT DE LIMPEZA DE DADOS DA BASE DE DADOS DO SIP - SEI 2.6.0 (ORACLE)
*/

/* Reconstrui as tabelas de log e auditoria e tabelas sequenciais correspondentes */
truncate table infra_auditoria;
exec reset_seq('sei.seq_infra_auditoria');

truncate table infra_log;
exec reset_seq('sei.seq_infra_log');


/********************************************************************************************************************************************************/