Re: import to another user

From: Martin Drautzburg <martin.drautzburg_at_web.de>
Date: 29 May 2002 00:06:26 +0200
Message-ID: <87znyk0vx9.fsf@web.de>

"zeb" <thierry.constant2_at_wanadoo.fr> writes:

> I create a new user B with:
> default tablespace TB
> connect role
>
> 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

What did happen to the unique/primary key BV_ACCT_PMT(PMT_ID) ? On the original database there must have been such a constraint or you couldn't have established the FK constraint. Where did it go ? Received on Tue May 28 2002 - 17:06:26 CDT