Oracle 10g edition

[Slm]

Can someone pls tell how to create a control file that will be used to load data in oracle db by using sql loader

 

[Leney]

Kwa kweli najitahidi kukuelewa, ila nashindwa,
unataka kuload data kwenye database yako using sqlloader but you want guidance? au umeshaandika control file and ur data file ila umekwama somewhere?
always make sure you invoke the sqlldr utility (kwenye command line chapa C:\sqlldr) ili uone kama ina function na if you wana change any parameters.

Ila kama unataka msaada wa kutengeneza the control file to suit ur needs nenda hapa, its short and clear; Oracle SQL*Loader: The Definitive Guide: Chapter 1: Introduction to SQL*Loader

Otherwise kama umekwama, tell me exactly where maana nashindwa kukusaidia. pia unatumia oracle yako katika platiform gani?

 

[Slm]

Samahani kwa kutokunielewa tatizo ni hili, after starting sqlldr utility using os and issue a command i get this error 'controlfile cannot be found' while in mind know that i have arleady created it using a text editor(notepad) on windows platform provided that sql script written in the notepad that will tell sqlldr where exactly data to be loaded is located is correct. The problem is exactly with the controlfile i hav created I am using windows please help me.

 

[Zing]

have u gooogled it? if not do. if yes tell the solution u have tried so tha we can help find other alternatives.

When u created it which location did u save it? . and what is the path of of data file and logs files

Managing Control Files

Look at this tooo http://forums.oracle.com/forums/thread.jspa?threadID=306974

 

[Leney]

Samahani kwa kutokunielewa tatizo ni hili, after starting sqlldr utility using os and issue a command i get this error 'controlfile cannot be found' while in mind know that i have arleady created it using a text editor(notepad) on windows platform provided that sql script written in the notepad that will tell sqlldr where exactly data to be loaded is located is correct. The problem is exactly with the controlfile i hav created I am using windows please help me.

Kama unapata hiyo error asilimia kubwa sana control file halipo kwenye current directory (yaani directory unayotumia ku issue hiyo sqldr command) halafu vilevile wewe hujaspecify path ya file lako. kuepukana na hili tatizo chukua control file lako kalipaste kwenye directory moja na sqlldr.exe (kwangu mimi sqlldr.exe inapatikana hapa C:\oraclexe\app\oracle\product\10.2.0\server\BIN) and make sure kabla hujaissue command ya sqlldr, make C:\oraclexe\app\oracle\product\10.2.0\server\BIN your current directory.

Hiyo niliyokupa njia mojawapo, nyingine ni kuspecify the path of the control file.

Swali:
data file lako unaconnect vipi na control file lako? For me I write them differently (mydata.dat, and mycontrolfile.ctl) then kwenye commandline na issue the following command;

C:\oraclexe\app\oracle\product\10.2.0\server\BIN> sqlldr username/password control=mycontrolfile data=mydata

 

[Leney]

have u gooogled it? if not do. if yes tell the solution u have tried so tha we can help find other alternatives.

When u created it which location did u save it? . and what is the path of of data file and logs files

Managing Control Files

Look at this tooo OTN Discussion Forums : How to re-create controlfile ...

Exactly, issue yake ni location ya file/path, hamna kingine au maybe hana sqlldr executable file, but sidhani maana hii inakuja na oracle 10g

 

[Slm]

Thank you leney am going to place my controlfile in the same directory where sqlldr.exe is located and see what will happen. And about controfile and data file I create them differently but in the control file the full path of the data file is identified

 

[Slm]

Exactly, issue yake ni location ya file/path, hamna kingine au maybe hana sqlldr executable file, but sidhani maana hii inakuja na oracle 10g

no I do have sqlldr executable file

 

[Leney]

Thank you leney am going to place my controlfile in the same directory where sqlldr.exe is located and see what will happen. And about controfile and data file I create them differently but in the control file the full path of the data file is identified

OK.
about the control file and the data file, yes you could do that, or you could just write the filename kwenye control file e.g (LOAD DATA INTO TABLE bla bla...) halafu kwenye commandline ukaweka data file name kama nilivofanya, both are okay.

 

[EvanMakundi]

Hi Guys

I am looking someone with Oracle Database 10g R2 Installer for Windows.
This version of Database is currently no longer available from Oracle Website for Download, unfortunately the CD i have got damaged and can not be used for Installation, and I do not want to use any latest version on my Application.

Is there someone with this CD (From Dar Es Salaam). I would appreciate if i could get a copy of this Database.

 

[paramawe]

Hi Guys

I am looking someone with Oracle Database 10g R2 Installer for Windows.
This version of Database is currently no longer available from Oracle Website for Download, unfortunately the CD i have got damaged and can not be used for Installation, and I do not want to use any latest version on my Application.

Is there someone with this CD (From Dar Es Salaam). I would appreciate if i could get a copy of this Database.

Ninayo ila sipo dar km utakosa dar nijulishe kw namba hii niangalie jinsi ya kkutumia nliyonayo.

 

[EvanMakundi]

Ninayo ila sipo dar km utakosa dar nijulishe kw namba hii niangalie jinsi ya kkutumia nliyonayo.

Mkuu Asante sana, hii ni habari Njema. Mpaka sasa sijapata mtu yeyote alienayo hapa Dar.
Nimeku-PM