Re: Defragment SYSTEM Tablespace

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 10 May 1999 16:30:34 -0700
Message-ID: <37376C1A.11A23EE2@us.oracle.com>

Arndt

An easy once to answer, less easy to implement. The only way to defragment the system tablespace is to recreate the database.

HTH. Pete

Arndt Humpert wrote:

> How do i defragment a fragmented system tablespace ?
> (The database was migrated from 7.3 to 8.0 .)
> Thanks
> Hp

Regards

Pete

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)

Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Mon May 10 1999 - 18:30:34 CDT