|
View previous topic :: View next topic
|
| Author |
Message |
nagamanjari
New User
Joined: 25 Apr 2008
Posts: 9
Location: hyderabad
|
|
|
|
Hi,
Can anyone suggest me how to load records from a flat file into table without any duplicate records, USING UTILITY like REPLACE or LOAD. |
|
| Back to top |
|
 |
Manuneedhi K
Active User
Joined: 07 May 2008
Posts: 115
Location: Chennai
|
|
|
|
The load utility will not load the duplicate records owing to the primary key constraints even if you have duplicates in this input file . You can try to have a sort to filter out the duplicates on the primary key if you want to remove them before the load step.
Thanks
Manu |
|
| Back to top |
|
|
|
|
