Home » RDBMS Server » Server Utilities » when to use SQL loader
when to use SQL loader [message #190548] Thu, 31 August 2006 04:36 Go to next message
gthrisg
Messages: 17
Registered: August 2006
Junior Member
For which tasks can i use SQL LOADER?

-gthri
Re: when to use SQL loader [message #190550 is a reply to message #190548] Thu, 31 August 2006 04:39 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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.
Re: when to use SQL loader [message #190553 is a reply to message #190550] Thu, 31 August 2006 04:42 Go to previous messageGo to next message
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
Re: when to use SQL loader [message #190560 is a reply to message #190553] Thu, 31 August 2006 04:53 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
No, export dump files use a proprietary file format. SQL*Loader can only be used to load data files.
Re: when to use SQL loader [message #190673 is a reply to message #190548] Thu, 31 August 2006 12:35 Go to previous messageGo to next message
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
Re: when to use SQL loader [message #190870 is a reply to message #190673] Fri, 01 September 2006 11:44 Go to previous messageGo to next message
joy_division
Messages: 4644
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.
Re: when to use SQL loader [message #191907 is a reply to message #190870] Fri, 08 September 2006 09:45 Go to previous messageGo to next message
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
Re: when to use SQL loader [message #192001 is a reply to message #191907] Sat, 09 September 2006 14:11 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: when to use SQL loader [message #192008 is a reply to message #190548] Sat, 09 September 2006 14:23 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: when to use SQL loader [message #193296 is a reply to message #192008] Fri, 15 September 2006 10:27 Go to previous message
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 228 times)
Previous Topic: Strange SQL Loader problem
Next Topic: Oracle documentation regarding full database export import operation
Goto Forum:
  


Current Time: Sat Dec 10 03:32:59 CST 2016

Total time taken to generate the page: 0.08357 seconds