import data file into Oracle database, using SQL*Loader utility … sqlldr … sql loader

use exp

For example, in the following example, benefits table has a column called v_status. This exp command will export only the rows that contains “INVALID” as value in the v_status column.

$ exp hradmin/mypassword TABLES=benefits query=\"where v_status=\'INVALID\'\"
About to export specified tables via Conventional Path ...
. . exporting table BENEFITS 20783 rows exported


SQL*Loader (sqlldr) is the utility to use for high performance data loads. The data can be loaded from any text file and inserted into the database.

螢幕快照 2014 09 03 上午10 42 12

Read more