Home » RDBMS Server » Server Utilities » SQL loader -- just a utility, BUT so COMPLICATED. (win xp, 9i)
SQL loader -- just a utility, BUT so COMPLICATED. [message #309868] Sat, 29 March 2008 08:09 Go to next message
oraclewannabe
Messages: 26
Registered: January 2008
Junior Member
Hi guys,

i am trying to load a data from an excel sheet into a table in my db.

I readup abt sql loader, and it has so many different parameters and each parameters has so many different variations and options . and data can be loaded with different conditions..

i tried reading the oracle documentation, but seriously i had a hard time understanding the documentation..

Any guys has a site or book that is suitable for dummies like me ?
SQL Loader for Dummies or something lidat..

2) i have save the file into csv and open the csv file with a notepad.

i contain 2000 records where each record take up only 1 column.

inside the notepad its like this

James
Peter
Alex
Pinky

from examples i seen from the web
can i say that oracle will know each row is a new record if it is in a new line or do i have to specify it?
because i only specifications that specifys that each column is separated by ',' by doesnt say how each row is seperated.

3) does anyone has a default control file for me to take look ? a simple one pls.

just for me to load my 2000 record of 1 column into a table of 1 column..

Thanks
Re: SQL loader -- just a utility, BUT so COMPLICATED. [message #309869 is a reply to message #309868] Sat, 29 March 2008 09:03 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Post what you have tried so far and tell us where you are stuck. Only then we will be in a position to help you. In the mean time read the oracle documentation.

Regards

Raj
Re: SQL loader -- just a utility, BUT so COMPLICATED. [message #309872 is a reply to message #309868] Sat, 29 March 2008 09:18 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm
Re: SQL loader -- just a utility, BUT so COMPLICATED. [message #309887 is a reply to message #309868] Sat, 29 March 2008 10:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle9i Database Utilities
Chapter 10 SQL*Loader Case Studies

Regards
Michel
Re: SQL loader -- just a utility, BUT so COMPLICATED. [message #309897 is a reply to message #309868] Sat, 29 March 2008 12:56 Go to previous message
oraclewannabe
Messages: 26
Registered: January 2008
Junior Member
nice case studies for me to read up michael thanks alot!

[Updated on: Sat, 29 March 2008 12:57]

Report message to a moderator

Previous Topic: UTL_FILE question part 2
Next Topic: Impdb
Goto Forum:
  


Current Time: Tue Dec 06 04:38:45 CST 2016

Total time taken to generate the page: 0.08927 seconds