OraFAQ Forum: Server Utilities » Ssql*Loader - Ignoring certain columns while loading

Home » RDBMS Server » Server Utilities » Ssql*Loader - Ignoring certain columns while loading

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

Ssql*Loader - Ignoring certain columns while loading [message #260285]

Sat, 18 August 2007 01:00

rons
Messages: 18
Registered: June 2007
Location: Scottland

Junior Member

Hi,

Oracle Ver- 9.2.0.7

I have following data in text file.

TABLE_A
=======
REGNO	NUMBER(5),
NAME	VARCHAR2(30),
GRADE	NUMBER(1),
TOTAL	NUMBER(5,2)

Data
====
101,Smith,1,720
102,Arnold,B,519
103,Jackson,1,623

While loading through SqlLoader/External table, I want to ignore 3rd column. Is it possible.

Regards,
Ronald.

Report message to a moderator

Re: Ssql*Loader - Ignoring certain columns while loading [message #260288 is a reply to message #260285]

Sat, 18 August 2007 01:27

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

Senior Member
Account Moderator

Yes have a look at:
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: sql*Loader - Ignoring certain columns while loading [message #260297 is a reply to message #260285]

Sat, 18 August 2007 03:58

rons
Messages: 18
Registered: June 2007
Location: Scottland

Junior Member

Thanks Michel,

It worked.

Regards,
Ronald.

Report message to a moderator

Previous Topic:	exporting table and the sequence associated
Next Topic:	import problems

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 21:46:43 CDT 2024