set echo ON;
spool /datos/p06b/log/salida_20170707P06AP06B64T00_relanzar.log;

DROP TABLE P06B64T00_ATENDERPETICION;
DROP SYNONYM P06B64S00;
DROP SEQUENCE P06B64SEQ00;

DROP TABLE P06B70T00_CORREDORES;
DROP SYNONYM P06B70S00;

DROP TABLE P06B76T00_ATENCLIENTE;
DROP SYNONYM P06B76S00;

DROP TABLE P06B79T00_DEFECLIENTE;
DROP SYNONYM P06B79S00;

DROP TABLE P06B72T00_SOCIOSEXP;
DROP SYNONYM P06B72S00;

DROP TABLE P06B74T00_ORGANOSDIREXP;
DROP SYNONYM P06B74S00;

DROP TABLE P06B80T00_CAPACIDADFINANCIERA;
DROP SYNONYM P06B80S00;

DROP TABLE P06B71T00_ENT_VINCULADAS;
DROP SYNONYM P06B71S00;

ALTER TABLE P06B20T00_CORREDORES DROP (
P06B20_ULTEJERINCORPORADO,
P06B20_ATENCPETICINCORPORADA);

exit;
