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

CREATE TABLE P06B63T00_CIFDEC (
	P06B63_EX_CAMPO1         	VARCHAR2(9) NOT NULL
)
TABLESPACE P0601E00;

CREATE SYNONYM P06B63S00 FOR P06B63T00_CIFDEC;

ALTER TABLE P06B63T00_CIFDEC ADD CONSTRAINT P06B63I00 PRIMARY KEY
	(P06B63_EX_CAMPO1) USING INDEX TABLESPACE P0602E00;

GRANT SELECT ON P06B63T00_CIFDEC TO P06A;
GRANT SELECT ON P06B63T00_CIFDEC TO P06;

insert into P06B63T00_CIFDEC (P06B63_EX_CAMPO1)
values ('XXXX');
insert into P06B63T00_CIFDEC (P06B63_EX_CAMPO1)
values ('XXXX');
insert into P06B63T00_CIFDEC (P06B63_EX_CAMPO1)
values ('XXXX');
insert into P06B63T00_CIFDEC (P06B63_EX_CAMPO1)
values ('XXXX');
insert into P06B63T00_CIFDEC (P06B63_EX_CAMPO1)
values ('XXXX');
insert into P06B63T00_CIFDEC (P06B63_EX_CAMPO1)
values ('XXXX');

COMMIT;

exit;
