Re: import loose constraints (8.1.7)

On Wed, 25 Sep 2002 21:44:27 +0200, "zeb" <thierry.constant1_at_free.fr> wrote:

>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
>
>

You must be using Broadvision. Lucky you. Fortunately for me that nightmare is over.

You don't have any public synonyms on the original schema, do you, and 2 users with almost every privilege.
Also to get accurate replies you need to post the *full* export and import commands, not an extract.
It also looks like you didn't use IGNORE=Y

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Sep 25 2002 - 15:53:26 CDT