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.
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.
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 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.
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.
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).
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With