Home » RDBMS Server » Server Utilities » sql loader (Oracle 9.0.0.2)
sql loader [message #340182] Mon, 11 August 2008 17:40 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: how to transfer data
Next Topic: sqlloader multiple into table clause
Goto Forum:
  


Current Time: Sun Dec 04 12:43:37 CST 2016

Total time taken to generate the page: 0.07087 seconds