How to import "loader" format data using SQLDeveloper?

import oracle-sqldeveloper sql-loader
leo picture leo · Mar 4, 2014 · Viewed 20.4k times · Source

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.

Answer

leo picture leo · Mar 10, 2014

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

Related questions

How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How do I include a JavaScript file in another JavaScript file?

Is there something in JavaScript similar to @import in CSS that allows you to include a JavaScript file inside another JavaScript file?

Read More
Call a function from another file?

Set_up: I have a .py file for each function I need to use in a program. In this program, I need to call the function from the external files. I've tried: from file.py import function(a,b) But …

Read More