Re: Need V6 defrag script

In article <CrsxHI.EnG_at_csn.org> derby_at_csn.org "Gary Smith" writes:

> Lee E Parsons (lparsons_at_world.std.com) wrote:
> : I have a remote location with a ugly fragmentation problem under V6. The
> : admin is relatively new, we dont have a modem hookup and they are running
> : a OS we dont have access to here.
 

> : This means 1) I cant dial in, 2) dont want them to try imp/exp and
> : 3) cant sent them a precompiled degrag program.
>
> I'm don't believe imp/exp will solve your fragmentation issue. From my
> experiences exporting the data with compress extents and then re-importing
> it seems to work because the data attempts to become contigious, however
> the fragments still exist. This can be checked by looking at the number
> of distinct block_id's from dba_free_space.
>
> : I could send them the source to one of the program I have but I dont
> : think they could get it compiled. Does any body have a sql script that
> : examines dba_extents and creates the create table/drop table statements
> : needed to coalesce the frags. I know they can run that.
>
> The only guaranteed method of de-fragging a ver 6x database that I'm aware
> of is to export the data with compress extents, then re-create the database
> using the reuse option with each named file.
>
> Please, if anyone knows anything differently, please post it here!!!

ORACLE have a free utility for defragmenting free space on V6 databases. Contact Worldwide Support and ask them for it.

Slainte mhath,
Stephen Lappin

+-----------------+
| +-------------+ |  Real Time Engineering Ltd.
| |  Real Time  | |  Capital House
| +-------------+ |  20 Park Circus
| Engineering Ltd |  Glasgow G3 6BE         Tel: +44 (0)41 332 9400
+-----------------+  Scotland U.K.          Fax: +44 (0)41 331 2509