0 Replies Latest reply: Mar 26, 2007 5:41 PM by 569195 RSS

    Migrar SQLBase a Oracle 9i

    569195
      I have many issues with the migration of my tables and its data from SQLBase by GUPTA Technologies to Oracle 9i, an example of my table that I can´t migrate is:

      -- Oracle 2007-03-09
      -- Autor :ABDREMA
      -------------------------------------------------------

      DROP TABLE REQUI_N2;
      CREATE TABLE REQUI_N2
      (CV_REQUI NUMBER (8,0) NOT NULL,
      CV_USUA VARCHAR2 (6) NULL,
      CV_DEPA VARCHAR2 (8) NULL,
      TIPO NUMBER (4,0) NULL,
      COSTO_TOT NUMBER (15,2) NULL,
      FECH_ECOM DATE NULL,
      DESCRIPTIVO VARCHAR2(100) NULL, -----EX-LONG:estaban vacios todos
      STATUS VARCHAR2 (1) NULL,
      MAN_AUTO VARCHAR2 (1) NULL,
      FECH_FCAP DATE NULL,
      FECH_MODI DATE NULL,
      FECH_CANC DATE NULL,
      FECH_SURT DATE NULL,
      CV_COMPRADOR VARCHAR2 (6) NULL,
      AD_CAT VARCHAR2 (1) NULL,
      AD_ESP VARCHAR2 (1) NULL,
      AD_COT VARCHAR2 (1) NULL,
      AD_OFI VARCHAR2 (1) NULL,
      EMBARQUE VARCHAR2(300) NULL, ----EX-LONG: ALGUNOS USADOS
      USO VARCHAR2(500) NULL,      --EX-LONG:USADOS CASI TODOS CON MUCHA INFO
      PROV_SUG VARCHAR2(400) NULL, ---EX-LONG:MAYORIA USADOS
      MONTO_TOT NUMBER (15,2) NULL,
      TOT_MN NUMBER (15,2) NULL,
      FECH_NEC DATE NULL,
      PARTIDA_PRESUP VARCHAR2 (4) NULL,
      CENTRO_COSTO VARCHAR2 (6) NULL,
      LUGAR_ENT VARCHAR2 (6) NULL,
      TIPO_MONEDA VARCHAR2 (3) NULL,
      FECH_GTE DATE NULL,
      FECH_CP DATE NULL,
      CONTROL_PRESUP VARCHAR2 (12) NULL,
      CV_RESPONSABLE VARCHAR2 (6) NULL,
      CV_REQUI2 NUMBER (8,0) NULL,
      JUSTIFICACION VARCHAR2 (250) NULL,
      CV_INVITA NUMBER (8,0) NULL,
      DIRECTOR_AUTORIZA VARCHAR2 (6) NULL,
      GERENTE_AUTORIZA VARCHAR2 (6) NULL,
      FECHA_DIR DATE NULL,
      FECHA_GER DATE NULL,
      IMPUESTO CHAR (1) NULL,
      ORDEN_ID NUMBER (8,0) NULL,
      COMENTARIO VARCHAR2(100) NULL,          ---EX-LONG: TODOS VACIOS
      RESULTADO VARCHAR2(100) NULL, ---EX-LONG: TODOS VACIOS
      AREA_COORDINA_ORI NUMBER (8,0) NULL,
      NOTIFICADA NUMBER (8,0) NULL,
      FECHA_NOTIFICACION DATE NULL,
      FECHA_CANCELACION DATE NULL,
      MODIFICA_CV_PEDIDO NUMBER (8,0) NULL,
      APLICADA_MODIFIC CHAR (1) NULL,
      GASTOS_ASOCIADOS NUMBER (15,2) NULL,
      CV_SOLICITANTE VARCHAR2 (6) NULL,
      TIPO_PROVEEDOR CHAR (1) NULL,
      CONSTRAINT PK_REQUI_N2 PRIMARY KEY (CV_REQUI)
      USING INDEX TABLESPACE S_ADQUISICIONES_IDX,
      FOREIGN KEY (CV_INVITA) REFERENCES ABDREMA.INVITACIONES
      )
      PCTFREE 20 PCTUSED 75
      STORAGE ( INITIAL 5 M NEXT 5 M PCTINCREASE 50)
      TABLESPACE S_ADQUISICIONES_DAT;

      The types in SQLBase is LONG and I enable this as VARCHAR2 in Oracle, but at the time wich I execute the INSERT they show me the next error: 21722 and only is with the tables wich contains types LONG, realy I need your help.

      Receives my regards....cesmen001@gmail.com