Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> constraints during imp/exp
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
![]() |
![]() |