INSERT INTO my_table SELECT * FROM my_ext_table;For more information on External Tables, read the Oracle Utilities Guide. Part III covers External Tables.
If the text file resides on the client side, then you'll have to install Oracle Client software on the workstation....
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
This should be OK since you were using "bcp," which requires you to install SQL Server client tools on the workstation. Once you have Oracle Client on the workstation, you can use Oracle's utility for loading text files into a table. This utility is called SQL*Loader. The document I referenced above also covers SQL*Loader in Part II. SQL*Loader can also be used on the database server in lieu of External Tables.
Either solution does essentially the same thing, as both SQL*Loader and External Tables use the same engine to read the contents of the text file.
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.