import to another user

From: zeb <thierry.constant2_at_wanadoo.fr>
Date: Tue, 28 May 2002 21:59:59 +0200
Message-ID: <3cf3e13a$0$231$626a54ce@news.free.fr>

Hi,

I have the following problem ( 8.1.7 )

I export a user A

I create a new user B with:
default tablespace TB
connect role

I import the A to user B ( fromuser=A touser=B ) tables and indexes go into tablespace TB with no error but for the constraints I have the following errors:

.....
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "BV_ACCT_DETAILS" ADD CONSTRAINT "BV_ACCT_DETAILS_PMT_ID_FK"
FO"
"REIGN KEY ("PMT_ID") REFERENCES "BV_ACCT_PMT" ("PMT_ID") ON DELETE CASCADE
"
"ENABLE NOVALIDATE"

IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:

"ALTER TABLE "BV_ACCT_PMT" ADD CONSTRAINT "BV_ACCT_PMT_PMTTYPE_ID_FK"
FOREIG"
"N KEY ("PMTTYPE_ID") REFERENCES "BV_PMT_TYPES" ("PMTTYPE_ID") ON DELETE
CAS"
"CADE ENABLE NOVALIDATE"

IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:

"ALTER TABLE "BV_ACCT_PMT" ADD CONSTRAINT "BV_ACCT_PMT_ACCOUNT_ID_FK"
FOREIG"
"N KEY ("ACCOUNT_ID") REFERENCES "BV_ACCOUNT" ("ACCOUNT_ID") ON DELETE
CASCA"
"DE ENABLE NOVALIDATE"

....

What I miss and what the right way to do that ???? Received on Tue May 28 2002 - 14:59:59 CDT