Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Import bug ? (IMP-00015)

Re: Import bug ? (IMP-00015)

From: Achille Carette <achyl_at_infonie.be>
Date: Mon, 12 Feb 2001 09:02:55 +0100
Message-ID: <3a8798b4$0$4493$73bec57d@news.be.uu.net>

No, i haven't specified the USERS tablespace when creating the indexes - useless since they will be created in the only tablespace in wich the user has a quota larger than 0. Import tries to recreate the objects in the tablespace they were when exported. It does the same for the tables - but doesn't fail for them.

"Annie STECZYCKI" <armoni_at_club-internet.fr> wrote in message news:961762$can$1_at_front1m.grolier.fr...
> Hi Achille,
>
> I think that your method is really good.
> But when you have created user1's index, have you specified the TABLESPACE
> users?
> I think you do, so import, try to re-create the indexes in this
 tablespace.
> So, have you tried to do "quota 0 on users" for the user user2?
>
> HTH
>
> Annie STECZYCKI
>
>
Received on Mon Feb 12 2001 - 02:02:55 CST

Original text of this message

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