Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

LOAD DATA INFILE equivalent in Oracle

I just was wodering if there's an equivalent to MySQL LOAD DATA INFILE statemnent in Oracle? I need it because I want to read from a huge textfile into a database table.

like image 774
Mikayil Abdullayev Avatar asked Jan 21 '12 12:01

Mikayil Abdullayev


People also ask

What is data load in Oracle?

Use the Data Load page to make more data available to your Oracle Autonomous Database. You can load data from files or databases, from links to external databases or cloud storage files, or from a live feed of data from cloud storage.

What is SQL Loader in Oracle?

SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. You can use SQL*Loader to do the following: Load data across a network.

What is CTL file in Oracle?

What Is a Control File? Every Oracle database has a control file. A control file is a small binary file that records the physical structure of the database and includes: The database name. Names and locations of associated datafiles and online redo log files.

What is SQL Loader in Oracle 12c?

Beginning with Oracle Database 12c, SQL*Loader has a feature called express mode that makes loading CSV files faster and easier. Most data files are in comma-separated values (CSV) format. With express mode, there is no need to write a control file for most CSV files that you load.


1 Answers

Oracle gives the SQLLoader commandline utility. But it relies on a proper formatting of the data file.

You can try to look at Oracle External Tables (e.g. you can link a csv file as an external table and see it as a table within Oracle).

Both solutions have pros and cons, but the big cons is that they still rely on data input format (so if you have a file ready for mysql, you may need to tweak it a bit).

like image 110
BigMike Avatar answered Oct 01 '22 15:10

BigMike