map

LOAD DATA
INFILE 'syb_dump.dat'
INTO TABLE YOUR_ORACLE_TABLE
REPLACE
TRAILING NULLCOLS
FIELDS TERMINATED BY '|'   -- adjust if needed
(
    -- Sybase col 1 → Oracle col 1
    INTERNIDENTITY        INTEGER EXTERNAL,

    -- 2 → 2
    INTERNINSTID          INTEGER EXTERNAL,

    -- 3 → 3
    INTERNVERSION         INTEGER EXTERNAL,

    -- 4 → 4 (Sybase datetime)
    INTERNTIMESTAMP       TIMESTAMP "YYYY-MM-DD HH24:MI:SS",

    -- 5 → 5
    INTERNRECTYPE         INTEGER EXTERNAL,

    -- 15 → 6
    COBSSENDERSUBID       CHAR(256),

    -- 10 → 7
    EVENTSTATUS           INTEGER EXTERNAL,

    -- 11 → 8
    EVENTTYPE             INTEGER EXTERNAL,

    -- 18 → 9
    MORECONDATA           CHAR(256),

    -- 7 → 10
    ORDERID               CHAR(256),

    -- 12 → 11
    ORDERVERSION          CHAR(32),

    -- 16 → 12
    RECONDATA             CHAR(256),

    -- 13 → 13 (inline BLOB)
    REPLAYMESSAGE         CHAR(4000),   -- adjust if BLOB can exceed 4000

    -- 17 → 14
    RIOMESSAGESRC         CHAR(256),

    -- 9 → 15
    RIOSTATEEVENT         CHAR(256),

    -- 8 → 16
    STOPID                CHAR(256),

    -- 14 → 17
    SYMBOL                CHAR(256),

    -- 6 → 18
    TRANSACTIONID         CHAR(256)
)