I was wondering if there was a way I can execute a SQL Loader script from SQL Plus.
We are using Oracle 10g.
Calling SQL Loader From SQL Plus
oraclesqlplus
Related Question
- Oracle RDS – Load Data from S3 Using SQL*Loader
- Connection with SQL*Plus to Oracle
- SQL*Plus – Connecting to Oracle Without a Listener
- SQL*Plus save current COLUMN settings
- Oracle SQL Loader – How to Call Trigger During SQL Loader Insert
- SQL Developer vs SQL*Plus – Why Does SQL Developer Update Oracle Data Dictionaries?
- Oracle Forms – How to Circumvent ORA-01775 Looping Chain of Synonyms
Best Answer
An alternative technique may be to use an external table. There is no need to take your CSV (or whatever) file and load it in a separate step. Simply declare your external table in the correct format (this is almost identical to a SQL*Loader parfile, but wrapped in a
CREATE TABLEstatement) and you can issue aSELECTdirectly against it, once the file is in the right place. It will create.BADand.LOGfiles, just like SQL*Loader for any records that can't be cast to the datatypes in the table. You could expect better performance too. These days I would consider SQL*Loader to be for legacy apps only.