How did you get the tables from Oracle into SQLite?
With a little Perl: https://github.com/glgraca/ora2sqlite