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

Home -> Community -> Usenet -> c.d.o.server -> Re: fregmentation question

Re: fregmentation question

From: Patrick Meyer <buckeye234_at_excite.com>
Date: Wed, 3 Apr 2002 16:05:34 +0000 (UTC)
Message-ID: <57fad94973f7cd45818ae484af6f6a27.61632@mygate.mailgate.org>


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.ORG
Received on Wed Apr 03 2002 - 10:05:34 CST

Original text of this message

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