Home » RDBMS Server » Server Administration » SQL*Loader input file directory and data file dynamic ?
SQL*Loader input file directory and data file dynamic ? [message #63635] Thu, 21 October 2004 15:39 Go to next message
LEE SHIN YOUNG
Messages: 4
Registered: October 2004
Junior Member
I am sorry, below posted sentence...because language is different...

SQL*Loader input file directory and data file dynamic ?

So May I ask a some question? In case next sentence,
I want make a control file and then execute sqlloader.(orcle8.0.5 under windows)

LOAD DATA
INFILE 'C:DashAPP.txt'
INTO TABLE APPLICATION_TEMP
(IUD             POSITION(01:01)   CHAR,
 REG_DATE        POSITION(02:11)   CHAR,
 DEPT_CODE       POSITION(12:17)   CHAR,
 ID                      POSITION(18:39)   CHAR)
and then  Also I want to load several textfile under 'C:Dash'
So that how to make a command dynamic filename in windows?
Thanks~

Report message to a moderator

Re: SQL*Loader input file directory and data file dynamic ? [message #63643 is a reply to message #63635] Fri, 22 October 2004 13:50 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
you can create it from sqlplus on the fly:

set wrap off
set linesize 100
set feedback off
set pagesize 0
set verify off
set termout off

spool c:test.ctl
prompt LOAD DATA
prompt INFILE *
prompt INTO TABLE &1
prompt REPLACE
prompt FIELDS TERMINATED BY '|'
prompt (...
SPOOL OFF;

Report message to a moderator

Previous Topic: how to add a listener for db
Next Topic: how to change default timestamp format at DB level?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 06:25:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.