OraFAQ Forum: Server Utilities » giving data file in command line instead of control file

Home » RDBMS Server » Server Utilities » giving data file in command line instead of control file

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

giving data file in command line instead of control file [message #72669]

Tue, 26 August 2003 12:56

Avadbala
Messages: 17
Registered: October 2002

Junior Member

Guys ,

I want to give the data file in the command line as it is dynamically created each day and want to pass this file to the sqlloader. How should be the control file ? and can i have a control file without a INFILE? can any one pl. give the syntax and the control file ex.
thanks in advance
Avad

Report message to a moderator

Re: giving data file in command line instead of control file [message #72670 is a reply to message #72669]

Tue, 26 August 2003 15:10

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

$ cat dept.ctl
load data
into table dept
fields terminated by ','
(
deptno,
dname,
loc
)

$ cat dept.dat
10,ACCOUNTING,NEW YORK
20,RESEARCH,DALLAS 
30,SALES,CHICAGO
40,OPERATIONS,BOSTON

$ sqlldr userid=dbadmin/auroville control=dept.ctl data=dept.dat

SQL*Loader: Release 9.2.0.1.0 - Production on Tue Aug 26 16:40:56 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 4

Report message to a moderator

Previous Topic:	access to imp/exp from db.client
Next Topic:	Default Value on a column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 12:52:02 CDT 2024