OraFAQ Forum: Server Utilities » when to use SQL loader

Home » RDBMS Server » Server Utilities » when to use SQL loader

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

when to use SQL loader [message #190548]

Thu, 31 August 2006 04:36

gthrisg
Messages: 17
Registered: August 2006

Junior Member

For which tasks can i use SQL LOADER?

-gthri

Report message to a moderator

Re: when to use SQL loader [message #190550 is a reply to message #190548]

Thu, 31 August 2006 04:39

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

As the name suggests, you can only use it to load data.

It's particularly handy for doing bulk data load loads.

Report message to a moderator

Re: when to use SQL loader [message #190553 is a reply to message #190550]

Thu, 31 August 2006 04:42

gthrisg
Messages: 17
Registered: August 2006

Junior Member

hi,
thnks for the reply .can i use to load from export dump file or can i use it to load from a flat file?

-gthri

Report message to a moderator

Re: when to use SQL loader [message #190560 is a reply to message #190553]

Thu, 31 August 2006 04:53

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

No, export dump files use a proprietary file format. SQL*Loader can only be used to load data files.

Report message to a moderator

Re: when to use SQL loader [message #190673 is a reply to message #190548]

Thu, 31 August 2006 12:35

goudelly
Messages: 52
Registered: August 2006
Location: India

Member

Hi,

You have data in text files, dat files or flat files. the same thing you want to insert into your oracle database.. you have to use the sql*loader.

Means through sql*loader you can insert the data from falt files.

Thanks,

Mohan Reddy G

Report message to a moderator

Re: when to use SQL loader [message #190870 is a reply to message #190673]

Fri, 01 September 2006 11:44

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

goudelly wrote on Thu, 31 August 2006 13:35

You have data in text files, dat files or flat files. the same thing you want to insert into your oracle database.. you have to use the sql*loader.

You don't have to. You can use external tables.

Report message to a moderator

Re: when to use SQL loader [message #191907 is a reply to message #190870]

Fri, 08 September 2006 09:45

goudelly
Messages: 52
Registered: August 2006
Location: India

Member

Hi,

She want to load the data into oracle tables. Not using the external tables.

thanks,

Mohan Reddy G

Report message to a moderator

Re: when to use SQL loader [message #192001 is a reply to message #191907]

Sat, 09 September 2006 14:11

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

OK, but what's wrong about inserting records from an external table into an Oracle table? Joy Division, if I understood what he means, said that SQL*Loader isn't the only way to do that. After all, one could open text file and SQL*Plus session beside it and write INSERT statements manually.

Report message to a moderator

Re: when to use SQL loader [message #192008 is a reply to message #190548]

Sat, 09 September 2006 14:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>You have data in text files, dat files or flat files. the same thing you want to insert into your oracle database.. you have to use the sql*loader.
HAVE TO, I think not.
Alternatively, read the flat files via UTL_FILE & then INSERT the data.

Report message to a moderator

Re: when to use SQL loader [message #193296 is a reply to message #192008]

Fri, 15 September 2006 10:27

goudelly
Messages: 52
Registered: August 2006
Location: India

Member

Hi,

> HAVE TO, I think not

anacedent

I am attaching the test file which contains the pipe delimited data. i am already inserted this data into scott.emp table.

Ok it is a very good argument to me to solve the your doubt on text file data.

Based on your request i will ready to post the sql*loader control files also.

Thanks,

Mohan Reddy G

Attachment: EMP.TXT
(Size: 0.63KB, Downloaded 1275 times)

Report message to a moderator

Previous Topic:	Strange SQL Loader problem
Next Topic:	Oracle documentation regarding full database export import operation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 23:42:27 CST 2024