You can try to use Heterogeneous Services (the new name for Transparent Gateways), but the only way to know if this will be fast enough is to test it out for your specific needs.
Aside from that, I would recommend using SQL*Loader to quickly load data from a text file into an Oracle database. You can perform a Direct Path Insert with SQL*Loader, which is much faster than a conventional insert. Another idea to try is to use External Tables (available in Oracle 9i and 10g). External tables use the same SQL*Loader engine, but you can interact with the data directly using SQL statements. In any case, testing will determine if these methods will be fast enough.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.