Home » RDBMS Server » Server Utilities » Sql Loader Problem
Sql Loader Problem [message #73246] Tue, 09 March 2004 01:06 Go to next message
Ramesh j.m
Messages: 1
Registered: March 2004
Junior Member
Hi i am using using the sqlloader in aix unix with option  SKIP_INDEX_MAINTENANCE= TRUE setttings thinking that the data load will be fast. But once the load is completed duplicate records will be inserted as well as indexex will be set to unusable state. what is the option to provide the records will be in in proper after the load.

I know i have to use the rebuild option but could any one give me the soltion that i will get the duplicate records in any of teh file or in any temrory table along with the settting the constrains or bringing back the table as normal it was.

This is very urgent could any one please help me..

 

Report message to a moderator

Re: Sql Loader Problem [message #73254 is a reply to message #73246] Tue, 09 March 2004 07:40 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> get the duplicate records in any of teh file or in any temrory table along with the settting the constrains

Please have a look at our earlier posting and followup with that...

http://www.orafaq.com/forum/t/25692/0/

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Previous Topic: oracle 8.1.7 data migration question
Next Topic: How to use a variable in a control file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 01:38:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.