Re: Anyway to reorganize the system tablespace?

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Mon, 25 Jan 1999 10:59:46 +0800
Message-ID: <36ABDE22.3E1B@bhp.com.au>

Timothy Leung wrote:
>
> I am looking for a way to defrag the tablespace SYSTEM. Since I cannot drop
> any object inside it. So I cannot re-organize it in a conventional
> way(export data, drop the objects, create objects).
>
> Thanks in advance!
> Tim

Is there any particular need ?

Access inside the catalog is almost totally optimised around the rule based optimiser - the vast majority of access is via index reads...

You could always export/import you entire database but is that really worth the effort ?
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Sun Jan 24 1999 - 20:59:46 CST