| Loading LOB Data in Length-Value Pair Fields [message #159149] |
Thu, 16 February 2006 06:51 |
AlinaC
Messages: 45
Registered: November 2005
Location: India
|
Member |
|
|
Loading LOB Data in Length-Value Pair Fields
Control File
LOAD DATA
INFILE 'sample.dat' "str '<endrec>\n'"
INTO TABLE person_table
FIELDS TERMINATED BY ','
(name CHAR(25),
1 "RESUME" VARCHARC(3,500))
Data file (sample.dat)
Johny Quest,479 Johny Quest
500 Oracle Parkway
jquest@us.oracle.com
... <endrec>
2 3 Speed Racer,000<endrec>
When I'm loading only one record is being inserted. Second record (2 3 Speed Racer,000) is inserted as a part of resume field of 1st record.
select count(*) is showing 1.
Regards,
Alina
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
