Home » RDBMS Server » Server Utilities » how to access sqlldr on network
how to access sqlldr on network [message #621422] Wed, 13 August 2014 04:34 Go to next message
jgjeetu
Messages: 365
Registered: July 2013
Location: www.Orafaq.com/Forum
Senior Member

i am using batch and control files to upload the data.
i am using client pc, now the problem is database is installed on server not on client
through which i have to import data , i am not able to access sqlldr ,
how can i use server pc's sqlldr to import data

following are the codes which i am using inside batch and control file.

Batch file code:-
D:\ORACLE\ORA81\BIN\sqlldr vcon/vcon@unr 
control=E:\UploadFile\CTL_UPLOAD_FILE.ctl 
LOG=E:\UploadFile\LOG_UPLOAD_FILE.LOG


CTL file code:-
OPTIONS (SKIP=0,ERRORS=999999)
load data
	infile 'H:\Q4_DATA_PLAN_JAN\Q4_DATA_PLAN_JAN.csv'
	append
	into table Q4_DATA_PLAN_JAN
fields terminated by "," optionally enclosed by '"' TRAILING NULLCOLS ( MSISDN_NO,CIRCLE,RECORD_TYPE)
Re: how to access sqlldr on network [message #621425 is a reply to message #621422] Wed, 13 August 2014 04:59 Go to previous message
Littlefoot
Messages: 21505
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
The beauty of SQL*Loader is that it runs perfectly on a client PC. All you have to do is to install it. How? For example, you could install the whole database (which would be overkill), or Express Edition (XE) which is much smaller, but the correct way is to download Oracle Client software, run the installer and install utilities you need - SQL*Loader in your case.
Previous Topic: data pump error
Next Topic: Load data from access database in oracle
Goto Forum:
  


Current Time: Sun Oct 13 18:42:16 CDT 2019