Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: import to another user
Thanks for the answer, but I onle want duplicate a user (scema) in the same
database
How can I do that ??????
"Martin Drautzburg" <martin.drautzburg_at_web.de> a écrit dans le message de
news: 87znyk0vx9.fsf_at_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 Thu May 30 2002 - 14:10:10 CDT