Xref: alice comp.databases.oracle.server:79480
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!newsfeed.berkeley.edu!ctu-gate!news.nctu.edu.tw!feeder.seed.net.tw!news.seed.net.tw!not-for-mail
From: "fumi" <fumi@tpts5.seed.net.tw>
Newsgroups: comp.databases.oracle.server
Subject: Re: 8.1.5 - Dual gone schizoid
Date: 1 Jan 2000 15:18:35 GMT
Organization: SEEDNet News Service
Lines: 12
Message-ID: <84l5sb$9q3$2@news.seed.net.tw>
References: <946563069.23198.0.nnrp-14.9e984b29@news.demon.co.uk> <386B3365.7587@yahoo.com> <386BAC5F.34FE4F4@us.oracle.com> <386BAE32.E1B21859@us.oracle.com>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300


Mark Townsend <mtownsen@us.oracle.com> wrote in message news:386BAE32.E1B21859@us.oracle.com...
> Jonathon - I've seen this happen after a database import - can't
> remember the exact sequence, but it is possible. Only seemed to affect
> dual - no other sys tables seemed to have duplicated rows. Fix is to
> simply delete the offending row.


This is possibile if you import data using IGNORE=Y option and there is no
unique or primary key constraints with the tables.