7

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.

leo
  • 3,528
  • 3
  • 20
  • 19
  • 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 Mar 04 '14 at 11:28
  • 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 Mar 10 '14 at 09:30

1 Answers1

2

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

leo
  • 3,528
  • 3
  • 20
  • 19
  • 9
    Well, this answer is not very satisfying, because the question explicitly asked about SQLDeveloper. – Tom Feb 24 '15 at 09:49
  • Agree with @Tom. I don't have the `sqlldr` command installed on my dev workstation, so there's no way it'll be on my customer's computer should I need it. – MBraedley Oct 27 '15 at 12:19
  • I want to import .ldr files. It's true that this way is not with SQLDeveloper, but it was useful for me and worked perfectly. So thanks. – yaki_nuka Nov 12 '15 at 22:40