 New to SQLloader Need help [message #126853] |
Wed, 06 July 2005 23:40  |
shazzyncs
Messages: 12
Registered: July 2005
Location: Malaysia
|
Junior Member |
|
|
|
Hie i'm very new to sqlloader can anyone help me to start using the sqlloader.how to install it,run it and actually to use it. Thank you so much..your help is highly appreciated. Thank you
|
|
|
|
|
|
| Re: New to SQLloader Need help [message #127022 is a reply to message #126918] |
Thu, 07 July 2005 21:14  |
shazzyncs
Messages: 12
Registered: July 2005
Location: Malaysia
|
Junior Member |
|
|
|
Hey Frank thanks for tip.I've read all the information on SQL*loader through the link u gave me. Now i already created my control and data file. when i try to execute SQL*loader showed some error messages. The error msgers are SQL-500,553 and 509. Do know what caused this error?Thank you for your help
|
|
|
|
| Re: New to SQLloader Need help [message #127027 is a reply to message #127022] |
Fri, 08 July 2005 00:26 |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
As per the Database Error Messages manual:
SQL*Loader-00500: Unable to open file (string)
Cause: SQL*Loader could not open the named file.
Action: Check the operating system messages below this one in the log file.
SQL*Loader-00553: file not found
Cause: The specified file cannot be found.
Action: verify that the correct name exists and whether the file is in the intended location.
SQL*Loader-00509: System error: string
Cause: A platform-specific error was returned during an operation. This message is used to display the text of the error.
Action: none
Best regards.
Frank
|
|
|
|
| Re: New to SQLloader Need help [message #127041 is a reply to message #127027] |
Fri, 08 July 2005 03:33 |
shazzyncs
Messages: 12
Registered: July 2005
Location: Malaysia
|
Junior Member |
|
|
|
Thanx Frank for the help..But i already double check my spellling and the location of my file. But still the errors are there.Am i missing anything???Is there somewhere i did it wrongly???Your help is highly appreciated.Thank you again
|
|
|
|
|
|
| Re: New to SQLloader Need help [message #127057 is a reply to message #127048] |
Fri, 08 July 2005 05:49 |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Do you have spaces or other strange characters in the path name? Have you checked if it's case sensitive?
Please post the command, control file and complete error so we can look at it.
If we cannot solve the problem here, you will need to log a TAR with Oracle Support for assistance.
Best regards.
Frank
|
|
|
|
|
|
 Re: New to SQLloader Need help [message #127264 is a reply to message #127263] |
Sun, 10 July 2005 22:57 |
shazzyncs
Messages: 12
Registered: July 2005
Location: Malaysia
|
Junior Member |
|
|
Dear Frank i need your opinion on this. I have a a csv file which consist of a record with a a few data fields. My problem is that some of the datas in the field are empty. can sqlldr import null value for some field??If can where do i set it. And i have one column that consists the following data. I put the datatype of the column as DATE. But it seems sqlldr rejected it because it's not a valid month.I need to import these file into the oracle.Do u have any suggestion???and one more thing can i set my date to "DD/MM/YY"??I tried to do that but the sqlldr trigger an error saying that invalid month.Really need your help.Thank u so much.Your help is highly appreciated.
Booking_Date
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
10/31/2001 12:00:00 AM
[Updated on: Mon, 11 July 2005 03:58] Report message to a moderator |
|
|
|
| Re: New to SQLloader Need help [message #127536 is a reply to message #126853] |
Tue, 12 July 2005 02:03 |
shazzyncs
Messages: 12
Registered: July 2005
Location: Malaysia
|
Junior Member |
|
|
Dear all..
i want to know is it possible to skip the first row of a record. I want remove the header of my table and only want to import the data required is there any way to do that???Your help is highly appreciated.Thank you again
|
|
|
|
|
|
|
|
| Re: New to SQLloader Need help [message #127846 is a reply to message #126853] |
Wed, 13 July 2005 11:34 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Not a problem, best way to learn is to read and then try it out on a test/dev database. Next time you get stuck post your question as a new topic and people we'll be happy to help if we can.
Oh and there is a sticky message on the sql/plsql newbie forum which is suggested reading for everyone.
[Updated on: Wed, 13 July 2005 11:36] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
thanx again for the advice n site u gave me and the help u guys gave me....i'll post more questions if i have any doubt about sqlldr.. 