# How to do a bulk insert into a Oracle

**URL:** <https://forum.knime.com/t/how-to-do-a-bulk-insert-into-a-oracle/64520>\
**Category:** KNIME Analytics Platform\
**Created:** [March 30, 2023, 7:50am UTC](https://forum.knime.com/t/how-to-do-a-bulk-insert-into-a-oracle/64520 "2023-03-30T07:50:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![hhkim](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/h/dfb087/32.png) [@hhkim](https://forum.knime.com/u/hhkim)\
**Post date:** [March 30, 2023, 7:50am UTC](https://forum.knime.com/t/how-to-do-a-bulk-insert-into-a-oracle/64520/1 "2023-03-30T07:50:16Z")

</div>

Hello.

I was wondering if I can do a bulk insert into Oracle.

As you know, DB Loader node can do a bulk insert but it support only Hive, MySQL, PostgreSQL, H2.

If there is a good method, I’d appreciate it if you could tell me.

Thanks,  
hhkim

---

<div class="post-metadata">

**Author:** ![tobias.koetter](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tobias.koetter/32/56844_2.png) [@tobias.koetter](https://forum.knime.com/u/tobias.koetter)\
**Post date:** [April 11, 2023, 3:44pm UTC](https://forum.knime.com/t/how-to-do-a-bulk-insert-into-a-oracle/64520/2 "2023-04-11T15:44:58Z")

</div>

Hello @hhkim ,  
KNIME Analytics Platform does not support bulk insertion into Oracle. As far as we know bulk insertion into Oracle is only possible using the [Oracle SQL Loader tool](https://www.oracletutorial.com/oracle-administration/oracle-sqlloader/) which needs to run on the same machine as the database. Since KNIME Analytics Platform can run anywhere and we only have a JDBC connection to the database we cannot use this method.  
So if you want to load lots of data into Oracle you will need to write the data into a CSV file to a file system that is accessible from the machine Oracle is installed on ([CSV Writer](https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.io.filehandling.csv.writer.CSVWriter2NodeFactory/) and [SSH Connector](https://hub.knime.com/knime/extensions/org.knime.features.base.filehandling/latest/org.knime.ext.ssh.filehandling.node.SshConnectorNodeFactory/)) and then execute the command on the Oracle machine ([External SSH Tool](https://hub.knime.com/knime/extensions/org.knime.features.ext.exttool/latest/org.knime.ext.ssh.node.ExtSSHToolNodeFactory/)) as described here: [SQL\*Loader - Step by Step Guide How to Load a Datafile Into a Table](https://www.oracletutorial.com/oracle-administration/oracle-sqlloader/)  
Bye  
Tobias

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [July 10, 2023, 3:45pm UTC](https://forum.knime.com/t/how-to-do-a-bulk-insert-into-a-oracle/64520/3 "2023-07-10T15:45:31Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.