Re: About fragmentation ..?

The Oracle way is exp/imp.
There are 3-party software for defragmentation of Oracle databases. (http://www.platinum.com)
I find there is allways a hot debate between DBA's on when to defrag a database, and a lot of litterature has been written on the subject. I normally do a rebuild of indexes from time to time, which is far more faster, (and secure than exp-rebuild database-imp) You must remember that fragmentation comes in more flavors. table fragmentation / row fragmentation.
Maybe you only need to defrag a single table.

best regards.
Carl Bruhn
crb_at_dde.dk

agi wrote:

> Dear all,
>
> Does anyone can tell me that is Imp/Exp the only way to
> de-fragmentation in Oracle ?
> If it is, and how do I know that my database need to be exp/imp ?
>
> Thanks in advance !!
>
> Agi Chen
Received on Thu Feb 04 1999 - 02:04:00 CST