Using OracleToSqlite, you can migrate from Oracle to SQLite easily and fast, just a few mouse clicks!
Copy table struct and data from Oracle to SQLite
Click “Wizard – Import All Tables” at task dialog.
then show the wizard.
1. Open Source Oracle.
2. Select Destination SQLite.
3. Select tables to migrate.
Will copy selected tables struct (field, primary key, index, auto increament, nullable) and data both.