SQL Server - ORACLE (Bulk Insert)

• river1

  SSC-Insane

  Points: 24309

  More actions

  September 22, 2010 at 7:12 am

  #148704

  Hi,

  I have implemented Bulk Insert to import data from txt files to SQL Server.

  People that work with Oracle at my company want to know if they can implement Bulk Insert in Oracle too.

  Do you SQL Server Gurus know what is the name of the BUlk Insert in Oracle?

  Thank you

• Oliiii

  SSCertifiable

  Points: 5328

  More actions

  September 22, 2010 at 8:06 am

  #1225615

  I think Data Pump to bulk load stuff between Oracles instances, and SQL*Load to load data from a flat file.

  Haven't tested so i'm not 100% sure, that's what the Oracle team shouted when i asked 🙂