We had a few issues importing the Butler schema into Oracle that should be relatively easy correct.
Oracle does not have a boolean data type for table columns. The column actual in table Datasetconsumers is a boolean in SQLite. We suggest changing that to varchar2(1) and adding a "actual in ('T','F')"check constraint in Oracle.
"Size" is a reserved word in Oracle. The size column in table posixdatastorerecords will need to be renamed.
"Group" is a reserved word in Oracle. The group column in table detector will need to be renamed.
There is a data type mismatch in constraint Dataset_fk6 between column detector (number) in table detector and column detector (varchar) in table dataset. Data types must match in columns defined in FK/PK constraints.