OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » About sql loader (Oracle 10g)

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

About sql loader [message #569433]

Fri, 26 October 2012 05:13

spatava
Messages: 12
Registered: April 2012
Location: Pune india

Junior Member

Hi,
I am having query regarding sql loader.
my data file is comm(,) seperated and I want to load the whole file in oracle table 'bill_temp' except 1st column data of data file.
e.g.
File name: bill_file.dat
fields seperated by comma ','
values are like
emp_id,emp_name,emp_sal,join_date

oracle table bill_temp having the below column:
emp_name,emp_sal,join_date

Here I want load the emp_name,emp_sal and join_date into oracle table bill_temp.
emp_id should not get loaded into table.

Is there any way to skip the loading of particular column data from data file into table?

Report message to a moderator

[Message index]

		About sql loader By: spatava on Fri, 26 October 2012 05:13
		Re: About sql loader By: muralikri on Fri, 26 October 2012 05:26
		Re: About sql loader By: muralikri on Fri, 26 October 2012 05:32
		Re: About sql loader By: spatava on Fri, 26 October 2012 05:37
		Re: About sql loader By: muralikri on Fri, 26 October 2012 05:52
		Re: About sql loader By: Michel Cadot on Fri, 26 October 2012 06:07
		Re: About sql loader By: muralikri on Fri, 26 October 2012 06:19
		Re: About sql loader By: Michel Cadot on Fri, 26 October 2012 09:14
		Re: About sql loader By: Solomon Yakobson on Fri, 26 October 2012 08:46
		Re: About sql loader By: Barbara Boehmer on Fri, 26 October 2012 12:17
		Re: About sql loader By: muralikri on Mon, 29 October 2012 00:51
		Re: About sql loader By: spatava on Mon, 29 October 2012 02:41
		Re: About sql loader By: dariyoosh on Fri, 26 October 2012 05:28

Previous Topic:	Impdp - Packge Body Import taking Huge Time
Next Topic:	Issue/failure in IMPDP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 14:25:07 CDT 2024