OraFAQ Forum: SQL & PL/SQL » Handle duplicates during direct load path in SQL LOADER

Home » SQL & PL/SQL » SQL & PL/SQL » Handle duplicates during direct load path in SQL LOADER

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Handle duplicates during direct load path in SQL LOADER [message #634989]

Wed, 18 March 2015 12:04

hemantakhandare@gmail.com
Messages: 5
Registered: March 2015
Location: Mumbai

Junior Member

Hi Experts,

I have table with partition and my sql direct load most of the time due to duplicate data my loader left table index in unusable state so i want to handle this condition .Any help. I dont want to change my loader mechanism as direct =true ,just want to handle it .

Below is my table structure

Thanks in advance
Have nice day

[EDITED by LF: applied [spoiler] tags to cut a looooong story short]

[Updated on: Thu, 19 March 2015 01:07] by Moderator

Report message to a moderator

Re: Handle duplicates during direct load path in SQL LOADER [message #634995 is a reply to message #634989]

Wed, 18 March 2015 13:20

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Remove the unique constraint, handle your duplicate and recreate the unique constraint.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals.

Report message to a moderator

Re: Handle duplicates during direct load path in SQL LOADER [message #634997 is a reply to message #634995]

Wed, 18 March 2015 13:55

hemantakhandare@gmail.com
Messages: 5
Registered: March 2015
Location: Mumbai

Junior Member

Thanks sir,
but my partition table has unique index.

Report message to a moderator

Re: Handle duplicates during direct load path in SQL LOADER [message #634998 is a reply to message #634997]

Wed, 18 March 2015 14:04

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Recreate it as non unique.

[Updated on: Wed, 18 March 2015 14:04]

Report message to a moderator

Re: Handle duplicates during direct load path in SQL LOADER [message #635009 is a reply to message #634989]

Thu, 19 March 2015 00:48

hemantakhandare@gmail.com
Messages: 5
Registered: March 2015
Location: Mumbai

Junior Member

My unique index is local partition across all its subpartition.

Report message to a moderator

Re: Handle duplicates during direct load path in SQL LOADER [message #635012 is a reply to message #635009]

Thu, 19 March 2015 01:20

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And?

Report message to a moderator

Previous Topic:	Optimization ideas in view creation of subselect
Next Topic:	SQL date overlapping

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 15:47:41 CDT 2024