Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 13957 invoked from network); 4 Jul 2007 11:22:18 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 4 Jul 2007 11:22:16 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 70BC270D4F0; Wed, 4 Jul 2007 12:20:07 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03949-10; Wed, 4 Jul 2007 12:20:07 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E852E70D84B; Wed, 4 Jul 2007 12:20:06 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 04 Jul 2007 11:39:29 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F364D70D114 for ; Wed, 4 Jul 2007 11:39:28 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30834-01 for ; Wed, 4 Jul 2007 11:39:28 -0400 (EDT) Received: from bay0-omc2-s7.bay0.hotmail.com (bay0-omc2-s7.bay0.hotmail.com [65.54.246.143]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 40B8D70CF1F for ; Wed, 4 Jul 2007 11:35:00 -0400 (EDT) Received: from hotmail.com ([65.55.152.23]) by bay0-omc2-s7.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 4 Jul 2007 08:36:41 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 4 Jul 2007 08:36:40 -0700 Message-ID: Received: from 206.47.249.252 by BAY141-DAV13.phx.gbl with DAV; Wed, 04 Jul 2007 15:36:36 +0000 X-Originating-IP: [206.47.249.252] X-Originating-Email: [ganstadba@hotmail.com] X-Sender: ganstadba@hotmail.com From: "Michael McMullen" To: , References: Subject: Re: unique constraint violation on 8i import but not on 9i Date: Wed, 4 Jul 2007 11:36:36 -0400 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-OriginalArrivalTime: 04 Jul 2007 15:36:40.0629 (UTC) FILETIME=[1DE16E50:01C7BE51] X-archive-position: 50504 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: ganstadba@hotmail.com Precedence: normal Reply-to: ganstadba@hotmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Get off your high horse. You could ask if the table was precreated or had any rows. But I thought that might have been implied with that I was rebuilding the database. Indeed it does take time as I'm recovering a 750GB database on desupported hardware and oracle version. But more info, I am importing the table newly created in both databases. When I need a break I troubleshoot a bit more. The log from the export shows 2226980 rows exported. Same number of rows imported in both the 8i and 9i database. 8i has about 10 duplicates, those records don't exist in the 9i version. ----- Original Message ----- From: "Alex Gorbachev" To: Sent: Wednesday, July 04, 2007 8:56 AM Subject: Re: unique constraint violation on 8i import but not on 9i > Why on earth would someone think that the problem would be resloved > faster with guess than with proper trobleshooting? > How much time would it take to check content of the table and see that > there were any rows already before the import? > > -- http://www.freelists.org/webpage/oracle-l