Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have one text file contained data i want to load it into database which am connecting though jdbc connection oracle sql developer.

How can set the connection string to run that sqlldr exist in external dabase.

What I have tried:

sqlldr userid='user/user123@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.01)(PORT=1521))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=tns)))'  
CONTROL=RRP_B_E_01082016new.ctl LOG=D:RRP_B_E_01082016new.log BAD=D:RRP_B_E_01082016new.bad skip=1   
Pause  
Posted
Updated 9-Mar-20 8:50am
Comments
ZurdoDev 9-Mar-20 8:49am    
I do not understand what you are asking.

1 solution

You can use sqlplus to issue commands to an Oracle instance from command line:
SQL*Plus Quick Start[^]
SQL*Plus® User's Guide and Reference - Contents[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900