Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: import to another user

Re: import to another user

From: zeb <thierry.constant2_at_wanadoo.fr>
Date: Thu, 30 May 2002 21:10:10 +0200
Message-ID: <3cf6788b$0$233$626a54ce@news.free.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US