Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> import loose constraints (8.1.7)
Hi,
I have to duplicate a schema BV
so I create a new user, BV2, with his own tablespace
I export BV
... owner=BV
I import:
... fromuser=BV touser=BV2
During the import I have a lot of errors about constraints:
Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
set
. importing BV's objects into BV2
. . importing table "BV_ACCOUNT" 375 rows importedIMP-00015: following statement failed because the object already exists:
. . importing table "BV_ACCT_DETAILS" 0 rows imported . . importing table "BV_ACCT_PMT" 0 rows importedIMP-00015: following statement failed because the object already exists:
. . .
and I loose all my constraints
Why I have these errors ?
What is the right way to duplicate a schema ????
Thanks in Advance
Oracle 8.1.7
HP-UX 11.0
Received on Wed Sep 25 2002 - 14:44:27 CDT
![]() |
![]() |