OraFAQ Forum: Server Utilities » how to access sqlldr on network

Home » RDBMS Server » Server Utilities » how to access sqlldr on network

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to access sqlldr on network [message #621422]

Wed, 13 August 2014 04:34

jgjeetu
Messages: 373
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)

Report message to a moderator

Re: how to access sqlldr on network [message #621425 is a reply to message #621422]

Wed, 13 August 2014 04:59

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	data pump error
Next Topic:	Load data from access database in oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 01:18:42 CST 2025