-
The joys of UNIX-style operating systems.
There's always a way to do what you want. It just might take you forty years to fine the correct options
The really sad thing is I've used that import method before (years ago) and I completely forgot. Chump.
Cheers
Tim...
-
you can check note 191043.1
you can even define "-" as stdin in the controlfile then do
Code:
LOAD DATA
INFILE "-"
TRUNCATE
INTO TABLE LDR_TEST
FIELDS TERMINATED BY ";"
(
ID,
TEXT
)
cat $1 | sqlldr scott/tiger control=LDR3.CTL
-
This is how my control file look like.
load data
infile "-"
append
into table test
fields terminated by ' '
TRAILING NULLCOLS
(empid ,
empname ,
empdate)
anandkl
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|