Xref: alice comp.databases.oracle.server:83050 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!colt.net!diablo.theplanet.net!newsfeed.ision.net!ision!LF.net!not-for-mail From: Andreas Michler Newsgroups: comp.databases.oracle.server Subject: Re: constraints during imp/exp Date: Wed, 02 Feb 2000 15:34:19 +0100 Organization: LF.net GmbH, Stuttgart, Germany Lines: 41 Message-ID: <3898406B.FE2507BC@adicom.de> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news.lf.net 949501922 1926 194.233.107.87 (2 Feb 2000 14:32:02 GMT) X-Complaints-To: usenet@news.LF.net NNTP-Posting-Date: 2 Feb 2000 14:32:02 GMT To: jcollins@sasquatch.com X-Mailer: Mozilla 4.7 [en] (WinNT; I) X-Accept-Language: en Say constraints=y in your export parameter file. Before export create only the schema user, not the tables, they will be automatically created at import time. jcollins@sasquatch.com wrote: > 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@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! -- ------------------------------------- ADICOM Informatik GmbH Andreas Michler Wiesfleckenstr. 34 72336 Balingen Tel: 07433/9977-57,Fax: -90 E-Mail: Andreas.Michler@adicom.de http:\\www.adicom.de -------------------------------------