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 -> constraints during imp/exp

constraints during imp/exp

From: <jcollins_at_sasquatch.com>
Date: Tue, 1 Feb 2000 17:57:47 -0800
Message-ID: <Pine.NEB.4.21.0002011744360.19752-100000@seashell.sasquatch.com>


problem is: i do an export from my 8.0.5 db and import into 8.1.5 and i get unique key and primary key constraint violations when either i or the exp utility tries to enable them.

here are the specifics:
export from nt 8.0.5 enterprise with utf8 charset.

parfile looks like this:
file=exp_foo.dmp
log=exp_foo.log
owner=foo
compress=y
rows=y
constraints=n
grants=n
indexes=n

import into sparc/solaris 2.6 8.1.5 with utf8 charset.

imp system/foo_at_bar file=exp_foo.dmp log=imp_of_exp_foo.log fromuser=foo touser=foo

the really weird thing is that the constraint is enambled and on the source db and when you exp a search for uniqueness yields 82 identical rows! Received on Tue Feb 01 2000 - 19:57:47 CST

Original text of this message

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