Re: defragmentation of Oracle database

From: MotoX <rat_at_tat.a-tat.com>
Date: 1998/07/08
Message-ID: <899882318.14566.0.nnrp-10.c2de712e@news.demon.co.uk>#1/1

Kin Yee Lee wrote in message <6nu7sf$ibi_at_ds2.acs.ucalgary.ca>...
>Hi,
> Instead of using import/export to disk to defrag. the database,
>is it possible that it could done by import/export to tape to defrag. ?

Yes, you can imp/exp to/from tape. Check the Oracle docs. You can also do it to disk via a 'piped compress' on UNIX to dramatically reduce the amount of disk space the export file would require, and also get you around any max filesize limits your system may have.

MotoX

>Is there any commerical software to do that ?
>
>Thank you for any help in advance.
>
>kin
>
Received on Wed Jul 08 1998 - 00:00:00 CDT