Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: unique constraint violation on 8i import but not on 9i

Re: unique constraint violation on 8i import but not on 9i

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Wed, 4 Jul 2007 11:36:36 -0400
Message-ID: <BAY141-DAV13F2851B8DE46084B6C01BA6030@phx.gbl>


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" <ag_at_oracloid.com> To: <oracle-l_at_freelists.org>
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
Received on Wed Jul 04 2007 - 10:36:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US