3 ms·
> XE can be used for free > XE has hard limits on size and limits on active CPUs So no, it can't be used for free, you will pay for that with your time to kee
by tpm 8mo ago
> XE can be used for free
> XE has hard limits on size and limits on active CPUs
So no, it can't be used for free, you will pay for that with your time to keep it in usable state. We had to use it as our dev dbs because our customers used it and the size limit was a huge PITA. We mostly use MSSQL as dev db now because the other half of customers use that (we have to support both in the end) and it is way worse in every other way but there is no size limit for dev use.
- chasil 8mo agoYou can configure client ODBC in the listener.ora, then use database links to access outside sources. Here is how I did it with SQLite, which was problematic with anything but basic types. https://www.linuxjournal.com/content/sqlite-extraction-oracle-tables-tools-methods-and-pitfalls https://www.linuxjournal.com/content/sqlite-extraction-oracl...