CREATE TABLE Q0273T00 ( 
  TIPOPUBLI_ID_073     NUMBER (4)    NOT NULL, 
  TIPOPUBLI_DESC_073   VARCHAR2 (255), 
  TIPOPUBLI_DESE_073   VARCHAR2 (255),   
  CONSTRAINT PK_Q0273T00
  PRIMARY KEY ( TIPOPUBLI_ID_073 ) 
    USING INDEX 
     TABLESPACE Q0202E00 PCTFREE 10
     STORAGE ( INITIAL 32768 NEXT 32768 PCTINCREASE 0 ))
   TABLESPACE Q0201E00
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 32768
   NEXT 32768
   PCTINCREASE 0
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 


INSERT INTO Q0273T00 ( TIPOPUBLI_ID_073, TIPOPUBLI_DESC_073, TIPOPUBLI_DESE_073) 
VALUES (1, 'Oferta Inmobiliaria', 'Eskaintza Inmobiliarioa'); 
INSERT INTO Q0273T00 ( TIPOPUBLI_ID_073, TIPOPUBLI_DESC_073, TIPOPUBLI_DESE_073) 
VALUES (2, 'Necesidad y Demanda', 'Beharra eta Eskaria'); 
INSERT INTO Q0273T00 ( TIPOPUBLI_ID_073, TIPOPUBLI_DESC_073, TIPOPUBLI_DESE_073) 
VALUES (3, 'Oferta y Necesidad', 'Eskaintza eta Beharra'); 
COMMIT;

CREATE SYNONYM Q02B.Q0273S00 FOR Q02B.Q0273T00;

COMMIT;