Xref: alice comp.databases.oracle.server:39619
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.cwix.com!206.63.63.70!nwnews.wa.com!brokaw.wa.com!not-for-mail
From: Dan Morgan <dmorgan@exesolutions.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Anyway to reorganize the system tablespace?
Date: Tue, 02 Feb 1999 15:10:09 -0800
Organization: EXE
Lines: 22
Message-ID: <36B785D0.38B24185@exesolutions.com>
References: <78fdp2$j19$1@news.ctimail.com>
Reply-To: dmorgan@exesolutions.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en

> 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).

ARIS sells a product that does this though its price may be a bit prohibitive.
Others possibly do as well.

In addition to the suggestion made by someone else about exporting and
reimporting there is another way if you have sufficient DASD.

First create a duplicate instance with the same tablespace names and sizes.
Second build a database link between the two.
Third move everything across.
Fourth delete the original instance and rename the new instance.

If you are properly prepared you should be able to keep your downtime to only a
few minutes.

Regards,

Daniel A. Morgan