Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Import bug ? (IMP-00015)
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