Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!easynet-quince!easynet.net!mephistopheles.news.clara.net!newspeer.clara.net!news.clara.net!iris.uk.clara.net
From: "Tom" <tomNOSPAM@teameazyriders.com>
Newsgroups: comp.databases.oracle.server
Subject: import issue between 8i and 9i
Date: Fri, 12 Dec 2003 12:41:16 -0000
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Complaints-To: abuse@clara.net (please include full headers)
X-Trace: 004ba4284179a360976121026928f4fe79d0ed1487606a10dde48cfe3fd9b815
NNTP-Posting-Date: Fri, 12 Dec 2003 12:44:05 +0000
Message-Id: <1071233045.75731.0@iris.uk.clara.net>
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:249964

Hi,

8.1.5 and 9.2.0.4

Yet more testing of my upgrades has highlighted a problem that google can't seem to remedy.

I have nightly exports of the 'old' 8i system being run each night with

exp user/pass buffer=x file=y log=z

this runs without error

i import these into the 9i system with

imp system/pass fromuser=user touser=user file=y log=z

again this finishes without error

The issue is that this users sequences do not appear to be either imported over or exported correctly although as i said i can see
no errors.

The actual error i get is

java.sql.SQLException: ORA-00001: unique constraint (XXXX.PK_XXXXX) violated

Does my syntax look correct for the sequences etc to be copied over OK - from imp help=y it seems to me as though it is

thanks for any help

Tom