reverse engineering the data model in ingress (with ER Studio by Embarcadero and with ODBC if ingress supports ODBC?), generate a Oracle SQL script to create the tables, ER Studio will generate script to create the tables, indexes, and constraints.

Get the data in plain txt file and load it to the tables
with SQL*Loader