Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: fregmentation question
Yes.
You should have done a coalesce after dropping the user and removing the objects.
HTH,
Patrick .......
"Syltrem" <syltremspammenot_at_videotron.com> wrote in message news:HuFq8.6016$a04.30638_at_tor-nn1.netcom.ca...
> Hi
>
> I am doing an import this morning.
> First I dropped and re-create the user who owns every object in tablespace
> FIN_DATA_SMALL then I started the IMPort which recreates all the objects.
>
> SHould I have done a coalesce before the IMP ?
>
>
> Syltrem
-- Posted via Mailgate.ORG Server - http://www.Mailgate.ORGReceived on Wed Apr 03 2002 - 10:05:34 CST
![]() |
![]() |