How to import loader format data using SQLDeveloper?

Question

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

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

Note. I cannot log in to the server running Oracle DB and I do not have sysdba privileges.

Answer 1

Install OracleClient_11gR2_W64.zip Package

Oracle home, for example. C: \ oracle \ product \ 11.2.0 \ client_1

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

C:\oracle\product\11.2.0\client_1\network\admin\tnsnames.ora, , . ACME.

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

: 64- Oracle 11gR2 Windows 7

Oracle 11gR2

• 64-: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html
  • win64_11gR2_client.zip Oracle Database 11g Release 2 Client (11.2.0.1.0) Microsoft Windows (x64) 615MB
• 32-: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html
  • win32_11gR2_client.zip Oracle Database 11g Release 2 Client (11.2.0.1.0) Microsoft Windows (32- ) 684MB

Answer 2

: deinstall.bat , , . Oracle_win64_11gR2_deinstall_11.2.0.1.0.

c:\tmp\Oracle_win64_11gR2_deinstall_11.2.0.1.0\deinstall>  deinstall.bat -home C:\oracle\product\11.2.0\client_1