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 […]