Re: ORA-01654

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3F5DD0F2.EEFB087E_at_remove_spam.peasland.com...
> > Does anybody know if there is an on line defragmentation tool available
for
> > Oracle, like the tools that are used to defragment disk drives without
> > reformatting?
>
> Why would you want such a tool? By defragmenting, what do you hope to
> accomplish?

Brian,

I would hope this could reduce free space fragmentation and avoid the type of extension failure Jeff describes in his original post. I believe defragmenting the data doesn't do much for performance but an on line defragmentation tool could avoid the need to manipulate tablespaces.

Regards,

Richard

> Thanks,
> Brian
>
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Wed Sep 10 2003 - 03:42:56 CDT