Sign in or 
Share this
Oracle Technology Network
Oracle Technology Network (OTN) is Oracle's official, interactive online/offline community for Oracle technical professionals (with ~6 million registrations). It professes to be the world's largest online community of developers, DBAs, and architects using Oracle products and industry-standard technologies (such as Java, Linux, PHP). Registration is free.In addition to comprising several community-oriented Web sites, OTN is also the sponsoring organization of the Oracle ACE Program (which recognizes nonemployee Oracle advocates for their contributions to the Oracle community) and OTN Developer Days Java/SOA workshops, and publishes Developer newsletters (for Java and .NET). Additionally it offers free downloads of most Oracle products under the terms of the OTN Development License.
OTN sponsors a full slate of community-focused activities at Oracle OpenWorld, including the OTN Lounge, OTN Night, and the Oracle OpenWorld Unconference.
Oracle Technology Network on kyte.tv
emocat |
Latest page update: made by emocat
, Apr 8 2009, 5:58 PM EDT
(about this update
About This Update
Edited by emocat
view changes - complete history) |
|
More Info: links to this page
|
| Started By | Thread Subject | Replies | Last Post | ||
|---|---|---|---|---|---|
| mansurshamsi | Find missing and duplicate records in over 500 million records. | 2 | Aug 13 2009, 3:02 AM EDT by gokhan.kucuk | ||
|
Thread started: Aug 7 2009, 3:35 PM EDT
Watch
I have two databases on same server. In DB2 I have already 400 million records. I tried to load more 100 million records from DB1 to DB2 on top of existing 400 million records but after an hour I got the unique constraint error from DB2. The load has been failed after inserting 70% records.
Now I have three tasks. First I have to find the duplicate record between DB1 and DB2. Second I have to find out the remaining 30% records. Third I have to re-load the remaining 30% records. I tried to find out the duplicates between DB1 and DB2 but my query is not ending. The unique constraint is based on composite key (charge_id, start_date). Can you give me the better and fast solution? |
|||||
Showing 1 of 1 threads for this page
