OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Control file

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

Control file [message #290465]

Sat, 29 December 2007 01:21

vanathi
Messages: 74
Registered: December 2007
Location: India

Member

Hi,

load data
append
into table PARTCORE3
fields terminated by "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS (
CONTACTCODE CHAR,
RELATIONSHIPTYPE CHAR,
PORTFOLIOCODE CHAR,
PROCESSED CONSTANT "N",
ID__ "db_seq_PART.nextval"
)

This control file's input is a csv.
Sample data is 1,zn7c001013-Owner,Owner,N7C001013.
I just need datas from the 2nd data. ie.zn7c001013-Owner.
I dont need that '1'.
Is it possible?...

Please advice.

Report message to a moderator

Re: Control file [message #290481 is a reply to message #290465]

Sat, 29 December 2007 02:01

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Use FILLER spec.

CONTACTCODE FILLER CHAR

Database Utilities
Part II SQL*Loader
Chapter 9 Field List Reference
Section Specifying Columns and Fields
Subsection Specifying Filler Fields

Regards
Michel

Report message to a moderator

Re: Control file [message #290489 is a reply to message #290481]

Sat, 29 December 2007 02:28

vanathi
Messages: 74
Registered: December 2007
Location: India

Member

Sorry Michel. Sad

I cant understand that link.
How can I use filler in that?

Please help me.

Thanks in advance.

Report message to a moderator

Re: Control file [message #290490 is a reply to message #290489]

Sat, 29 December 2007 02:35

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

http://www.orafaq.com/faqloadr.htm#SKIPCOL

Report message to a moderator

Re: Control file [message #290493 is a reply to message #290490]

Sat, 29 December 2007 02:40

vanathi
Messages: 74
Registered: December 2007
Location: India

Member

load data
append
into table PARTCORE3
fields terminated by "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS (
Field FILLER,
CONTACTCODE CHAR,
RELATIONSHIPTYPE CHAR,
PORTFOLIOCODE CHAR,
PROCESSED CONSTANT "N",
ID__ "db_seq_PART.nextval"
)

Is this okay?...

[Updated on: Sat, 29 December 2007 02:41]

Report message to a moderator