Re: import loose constraints (8.1.7)

<g>
Sybrand, don't you support sap now? or was it Niall who supported that... ;) If you do then how is your nightmare over?

BTW: I support bv .. and i know what you mean .. the nightmare just doesn't end .. to top it off .. there is bladerunner.

cheers,
Anurag

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:ud84pucltem9cs0pmio8gfc3rh2ph70o76_at_4ax.com...
> 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 - 20:22:50 CDT