Loading Huge data files to Oracle

What is the process that we use to load the data faster when there are millions of files?

reddysneha
Profile Answers by reddysneha Questions by reddysneha
Jul 7th, 2007
9
3616

Showing Answers 1 - 9 of 9 Answers

intelmental4
Profile Answers by intelmental4

Jul 23rd, 2007

1. BCP
2. Bulk Insert
3. DTS(SQL 2000) / SSIS(SQL 2005)

Ayush.sh
Profile Answers by Ayush.sh

Mar 31st, 2009

For loading data files or flat files into DB, Unix utility SQL Loader is best suited. can load milions of records in just few secs. Easy to use and compatible with Unix, shell, PERL. Uses control file(.ctl) and parameter file(.par)to direct instructions.

kirandba
Profile Answers by kirandba

Mar 31st, 2010

Use SSIS. But with in SSIS use SQL Server Destination adaptor instead of OLEDB Destination. But when we use SQL Server Destination adapter we can only run either on server or from SQL agent job.