sql loader [message #340182] |
Mon, 11 August 2008 17:40 |
thalladas
Messages: 16 Registered: August 2008
|
Junior Member |
|
|
Hi Everyone,
we are using SQL loader which is loading data from a file(.Dat) to table.
when i see the logs related to it.It sayz unique constraint violated for some of the records.So can anybody tell me how not get that error.can we mention any distinct option while selecting from the file(.dat file)?..if yes.do we need change the .ctl file or sqlldr command?and how?..
Please let me know,if you want see the .ctl file.
Thanks in advance,
|
|
|
Re: sql loader [message #340208 is a reply to message #340182] |
Mon, 11 August 2008 23:29 |
|
Michel Cadot
Messages: 68693 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You can do nothing with SQL*Loader but where is the problem? Just ignore these errors if they are "normal" for you
You can also use external table instead and then you can use DISTINCT or any other SQL.
Regards
Michel
|
|
|