Defragmentation

From: Himanshu Gupta <himanshu.gupta_at_luton.ac.uk>
Date: Fri, 17 Sep 1999 17:33:19 +0100
Message-ID: <37E26D4F.9C6B6135@luton.ac.uk>

Hello.

One of the tables in our database is highly fragmented. To improve the performance, we have been advised to de-frag the table. This table has many constraints and is used extensively in running of other applications.

Now I have following questions:-

Is it possible to de-frag a table without defragmenting the whole database?
Do I have to shut down the whole database in order to defrag the table? How?
What are the steps involved in degragmenting it.

We are using Oracle 7.3.2.3.2 and PL/SQL release 2.3.2.3.1

I would appreciate if you can send me any helpful comments (even short notes will do)at my following email addresses:-

himi_at_luton.ac.uk
himi_at_himanshu.freeserve.co.uk

Many thanks.

Himanshu. Received on Fri Sep 17 1999 - 11:33:19 CDT