Home » RDBMS Server » Server Utilities » Ssql*Loader - Ignoring certain columns while loading
Ssql*Loader - Ignoring certain columns while loading [message #260285] Sat, 18 August 2007 01:00 Go to next message
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.
Re: Ssql*Loader - Ignoring certain columns while loading [message #260288 is a reply to message #260285] Sat, 18 August 2007 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64107
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
Re: sql*Loader - Ignoring certain columns while loading [message #260297 is a reply to message #260285] Sat, 18 August 2007 03:58 Go to previous message
rons
Messages: 18
Registered: June 2007
Location: Scottland
Junior Member
Thanks Michel,

It worked.

Regards,
Ronald.
Previous Topic: exporting table and the sequence associated
Next Topic: import problems
Goto Forum:
  


Current Time: Mon Dec 05 04:31:06 CST 2016

Total time taken to generate the page: 0.07107 seconds