How to import "loader" format data using SQLDeveloper?

7
votes

How do I import data in "loader" format using SQL Developer?

SQLDeveloper can export data in "loader" format, so I would like to re-import it.

Note: I'm not able to login to the server on which the Oracle DB is running, and I don't have sysdba privileges.

1
importoracle-sqldevelopersql-loader
The OracleClient_11gR2_W64.zip package locally installs binaries like sqlplus and sqlldr. I'll try to convince them to connect to the remote DB... - leo
Agree to anyone who thinks this is a noob question. But took me more than an hour to figure out how to do it. - leo

1 Answers

1
votes

Install OracleClient_11gR2_W64.zip package

Oracle home e.g. C:\oracle\product\11.2.0\client_1

  • Oracle Database Utilities
  • SQL*Plus
  • Oracle Call Interface (OCI)
  • Oracle Net (don't know if necessary)

Edit the C:\oracle\product\11.2.0\client_1\network\admin\tnsnames.ora, add a configuration for your remote DB, e.g. named ACME.

sqlldr  scott/tiger@ACME  control=BATCH_REPORTS_DATA_TABLE.ctl log=BATCH_REPORTS_DATA_TABLE.ctl.log

Also read this: How to install Oracle 11gR2 64-bit client on Windows 7

Download Oracle client 11gR2