Re: normalization

From: Joseph Sumalbag <Joseph_sumalbag_at_bose.com>
Date: 1998/02/27
Message-ID: <34F6E36E.903@bose.com>#1/1

The traditional way to do the reorg is by export/drop/import .. The imp/exp utility comes with Oracle .. However this is sometimes very time consuming specially for VLDB ,

There are alot of tools that are available on the market that does the reorg much much better .. They made the data unloading faster and then use the SQLLoader to load it back ..

This scheme is a lot faster than the traditional way , with one catch though .... I cost plenty of $$$$$ .

Anne-Marie Ternes wrote:
>
> One more question:
>
> - in DB2, there is a "REORG" utility, used to reorganize the database,
> reduce fragmentation, rearrange the physical disposition of tables
> etc.
>
> Is there a similar tool for Oracle, or does Oracle do such a task
> implicitly?
>
> Thanks to everybody for all the help!!
>
> Anne-Marie
Received on Fri Feb 27 1998 - 00:00:00 CST