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

CREATE TABLE P06B62T00_RECEPCION_DEC (
	P06B62_RD_EJERCICIO         VARCHAR2(15) NOT NULL,
	P06B62_RD_FECHAINI       	DATE NOT NULL,
	P06B62_RD_FECHAFIN       	DATE NOT NULL
)
TABLESPACE P0601E00;

CREATE SYNONYM P06B62S00 FOR P06B62T00_RECEPCION_DEC;

ALTER TABLE P06B62T00_RECEPCION_DEC ADD CONSTRAINT P06B62I00 PRIMARY KEY
	(P06B62_RD_EJERCICIO) USING INDEX TABLESPACE P0602E00;

grant select on P06B62T00_RECEPCION_DEC to p06;
grant select on P06B62T00_RECEPCION_DEC to p06a;

COMMIT;

exit;
