Home » RDBMS Server » Server Utilities » Control file
Control file [message #290465] Sat, 29 December 2007 01:21 Go to next message
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.
Re: Control file [message #290481 is a reply to message #290465] Sat, 29 December 2007 02:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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

Re: Control file [message #290489 is a reply to message #290481] Sat, 29 December 2007 02:28 Go to previous messageGo to next message
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.
Re: Control file [message #290490 is a reply to message #290489] Sat, 29 December 2007 02:35 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

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

Re: Control file [message #290493 is a reply to message #290490] Sat, 29 December 2007 02:40 Go to previous messageGo to next message
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

Re: Control file [message #290497 is a reply to message #290493] Sat, 29 December 2007 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It seems, just try it now.

Regards
Michel
Re: Control file [message #290501 is a reply to message #290497] Sat, 29 December 2007 03:06 Go to previous message
vanathi
Messages: 74
Registered: December 2007
Location: India
Member
Thanks a lot Michel,Mohammad Taj.
It is working fine.

Smile
Previous Topic: import indexes to a specified tablespace
Next Topic: SQL * Loader usage in differentiating between the files
Goto Forum:
  


Current Time: Sun Dec 04 04:56:30 CST 2016

Total time taken to generate the page: 0.04256 seconds