Re: Eliminating index files

On Thu, 13 Mar 2003 00:42:34 +0100, Rick Denoire <100.17706_at_germanynet.de> wrote:

>I need to reorganize a Raid group. One LUN contains index files only,
>and instead of saving them, I would rather just remove them,
>reconfigure the LUN adding more harddisks, and then recreate the
>indexes. Saving and restoring through the network takes several hours.
>
>I wonder if the database would still start without the files belonging
>to the index tablespace. Of course, one could just drop the
>tablespace, but then I assume that it would not be possible to just
>rebuild the indexes any more. So how could I free index space without
>losing their definitions?
>
>Thanks
>Rick Denoire

The only other alternatives you have are: - moving the datafiles to a different disk - running export without exporting the data prior to reorganization. This will dump the create index statements which can be extracted with imp show=y

Dropping the tablespace is mandatory I am afraid. Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Mar 12 2003 - 23:47:07 CST