OraFAQ Forum: Forms » SQL Loader

Home » Developer & Programmer » Forms » SQL Loader

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

SQL Loader [message #114871]

Wed, 06 April 2005 00:19

hsinghalmrt
Messages: 51
Registered: March 2005

Member

Hi all,
how can we insert a text file data into the table and vice versa
using SQL Loader.

pls give the steps.

Report message to a moderator

Re: SQL Loader [message #114874 is a reply to message #114871]

Wed, 06 April 2005 00:47

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Look at http://www.orafaq.com/faq/sql_loader

Report message to a moderator

Re: SQL Loader [message #114913 is a reply to message #114874]

Wed, 06 April 2005 06:16

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Or at the manuals Very Happy

MHE

Report message to a moderator

Re: SQL Loader [message #114915 is a reply to message #114913]

Wed, 06 April 2005 06:21

hsinghalmrt
Messages: 51
Registered: March 2005

Member

yes i know but that is showing Error at the end of control file. Cool

Report message to a moderator

Re: SQL Loader [message #114920 is a reply to message #114915]

Wed, 06 April 2005 06:33

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Ahh..now we're getting somewhere.

you have received an error. Care to share it with the group?

While you're at it. Some DB and OS version info would be help too.

Did you evaluate the option of creating a directory object and an external table instead of using SQL*Loader?

[EDIT: external table option included]

MHE

[Updated on: Wed, 06 April 2005 06:34]

Report message to a moderator

Previous Topic:	Hi all
Next Topic:	I want to populate form (Daily Attendance Form).

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 06 03:51:19 CST 2025