Home » RDBMS Server » Server Utilities » Sql Loader
Sql Loader [message #619667] Thu, 24 July 2014 05:01 Go to next message
vatsav
Messages: 2
Registered: July 2014
Junior Member
Hi

Im trying to use the sql loader functionality to load the data from a flat file separated by '|' delimiter.

Im struck with a scenario where i have the data which looks like the below

1234|a1|a2|a3|a.xml,b.xml,c.xml,d.xml|a4|a5|a6

could you please help me out here

Re: Sql Loader [message #619669 is a reply to message #619667] Thu, 24 July 2014 05:06 Go to previous messageGo to next message
Littlefoot
Messages: 21598
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What's the problem, exactly?
Re: Sql Loader [message #619673 is a reply to message #619667] Thu, 24 July 2014 05:38 Go to previous messageGo to next message
Michel Cadot
Messages: 67370
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Database Utilities
Part II SQL*Loader

Re: Sql Loader [message #619675 is a reply to message #619669] Thu, 24 July 2014 05:47 Go to previous messageGo to next message
vatsav
Messages: 2
Registered: July 2014
Junior Member
I have used the below and trying to insert the sample data shown below

OPTIONS (ROWS=64)
LOAD DATA
characterset UTF8
INFILE '/amp/prosurv/sam/data/stats_customer.txt'
PRESERVE BLANKS
INTO TABLE NUPPAL1.STATS_CUSTOMER
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(col1,
Col2,
Col3,
Col4,
Col5,
Col6,
Col7)

Sample data
1234|a1|a2|a3|a.xml,b.xml,c.xml,d.xml|a4|a5|a6

In col5 i have data with a.xml,b.xml,c.xml,d.xml whihc I'm unable to insert in a singlecolumn

[Updated on: Thu, 24 July 2014 05:50]

Report message to a moderator

Re: Sql Loader [message #619682 is a reply to message #619675] Thu, 24 July 2014 06:15 Go to previous messageGo to next message
Littlefoot
Messages: 21598
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you provide STATS_CUSTOMER table description?
How about Oracle error you got (its code and meaning - not described by your own words)?
What's written in SQL*Loader's log file?
Re: Sql Loader [message #619685 is a reply to message #619682] Thu, 24 July 2014 06:33 Go to previous messageGo to next message
Michel Cadot
Messages: 67370
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

In clear, " I'm unable to insert in a singlecolumn" is meaningless for us.

Re: Sql Loader [message #619687 is a reply to message #619675] Thu, 24 July 2014 06:39 Go to previous message
John Watson
Messages: 8348
Registered: January 2010
Location: Global Village
Senior Member
Are you trying to insert into eight columns or seven?
Previous Topic: NLS_DATE_FORMAT in init.ora
Next Topic: ORA-31655: no data or metadata objects selected for job
Goto Forum:
  


Current Time: Mon Sep 28 11:52:53 CDT 2020