在Oracle中等效于LOAD DATA INFILE [英] LOAD DATA INFILE equivalent in Oracle

问题描述

我只是想知道在Oracle中是否有等同于MySQL LOAD DATA INFILE statemnent的信息?我需要它是因为我想从一个巨大的文本文件中读取一个数据库表.

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.

推荐答案

Oracle提供了 SQLLoader 命令行实用程序.但是它依赖于数据文件的正确格式.

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

您可以尝试查看 Oracle外部表(例如，您可以将一个csv文件链接为一个外部表，并在Oracle中将其视为一个表).

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).

这两种解决方案都有优点和缺点，但是最大的缺点是它们仍然依赖于数据输入格式(因此，如果您已经为mysql准备了文件，则可能需要对其进行一些调整).

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).

这篇关于在Oracle中等效于LOAD DATA INFILE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！