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 -> import loose constraints (8.1.7)

import loose constraints (8.1.7)

From: zeb <thierry.constant1_at_free.fr>
Date: Wed, 25 Sep 2002 21:44:27 +0200
Message-ID: <3d92110b$0$10512$626a54ce@news.free.fr>


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 imported
IMP-00015: following statement failed because the object already exists:
"ALTER TABLE "BV_ACCOUNT" ADD CONSTRAINT "BV_ACCOUNT_PK" PRIMARY KEY
("ACCO"
"UNT_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL
327"
"68 NEXT 32768 MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0 FREELISTS 1
FREELI"
"ST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "INTRADB" ENABLE "
. . importing table              "BV_ACCT_DETAILS"          0 rows imported
. . importing table                  "BV_ACCT_PMT"          0 rows imported
IMP-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

Original text of this message

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