Re: Import external data file

Actually, the script is rebuilding indexes, backing up tables/deletes old ones/rename the new ones with the old names and so one (recompile objects....)
when these objects are fragmented, and squeezing tablespaces a little bit when it is possible.

We are trying to do this because the Oracle databases from 8.0.5 to 9) are installed on small hard drives (actually, old big drives) using RAID 5
and what we want to do is to save 1 giga.

These databases are installed on different places, and we want to avoid to call someone to change the disks.

Regards

Antoine Tissier

"G Quesnel" <dbaguy_ott_at_yahoo.com> wrote in message news:<1105377204.561923.319040_at_c13g2000cwb.googlegroups.com>...
> Unless you are thinking of a table that has many segments, then you
> should be thinking of creating a dummy table with a small initial and
> next extent size, unless you are using locally managed tablespace, in
> which case ...
Received on Tue Jan 11 2005 - 02:43:13 CST