Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> import to another user
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:
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:
What I miss and what the right way to do that ???? Received on Tue May 28 2002 - 14:59:59 CDT