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

Home -> Community -> Usenet -> c.d.o.server -> Re: 8.1.5 - Dual gone schizoid

Re: 8.1.5 - Dual gone schizoid

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 1 Jan 2000 15:18:35 GMT
Message-ID: <84l5sb$9q3$2@news.seed.net.tw> 






Mark Townsend <mtownsen_at_us.oracle.com> wrote in message news:386BAE32.E1B21859_at_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.


Received on Sat Jan 01 2000 - 09:18:35 CST












Original text of this message













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