|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: problem in loading data from sql* loader [message #536867 is a reply to message #536858] |
Fri, 23 December 2011 08:09 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
You don't need sqlldr to create a control file. Use your favorite editor to create the control file YOURSELF. don't make someone else do it for you.
There are samples all over the internet. Do note though that without sqlldr, you will not be able to use it, so I do not see the point of either someone creating one for you or you creating it yourself.
|
|
|
Re: problem in loading data from sql* loader [message #536868 is a reply to message #536848] |
Fri, 23 December 2011 08:11 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
vickyminugmailcom wrote on Fri, 23 December 2011 07:19yes i have privilges for creating the external directory,but i dont know how o create
Then use external tables, but based on your questions, this is way beyond your comprehension. Plus, you would need access to putting the data file on the server, not the client.
|
|
|
Re: problem in loading data from sql* loader [message #536873 is a reply to message #536868] |
Fri, 23 December 2011 10:38 |
|
Barbara Boehmer
Messages: 9101 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
Let's start by confirming whether you have SQL*Loader or not for sure. Since you are using Windows, using your mouse, put the arrow on the start button in the lower left corner of your screen, then click the left mouse button, move your arrow to all programs, then click the left mouse button again, move your arrow to accessories, then click the left button again, move your arrow to command prompt, then click your left button again. From the DOS command prompt window go to the root directory by typing cd\ and pressing the enter key. Then search for any sqlldr files in any sub-directories by typing:
dir sqlldr.*/s
Then press the enter key. Wait for it to return to the c:\> prompt so that you know it has finished. Then post here what it displayed inbetween. Please copy and paste, if you can, instead of typing. If you left click in the upper left corner of the DOS command prompt window, you should be able to select edit and use the features to mark and copy, then paste it here, using ctrl-v. Please post the whole thing from the cd\ command to the return to the c:\> prompt.
Note that this is not the only method of searching for the file, but it is one that checks all directories and produces output that can be copied and pasted easily.
|
|
|
|