Home » RDBMS Server » Server Utilities » sql loader (Oracle
sql loader [message #340182] Mon, 11 August 2008 17:40 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64943
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.

Previous Topic: how to transfer data
Next Topic: sqlloader multiple into table clause
Goto Forum:

Current Time: Thu Jun 22 11:41:21 CDT 2017

Total time taken to generate the page: 0.09669 seconds