Re: Unfragment SYSTEM Tablespace

The easiest (?) way to unfragment the SYSTEM tablespace is to:

1. Do a full export of the database FULL=Y
2. Delete the database.
3. Recreate the database (run CATALOG and CATPROC too).
4. Import the full database FULL=Y

There is some work involved here, that's why I put the "?" above when I said "easiest". But all in all, it's not that difficult.

HTH,
Brian

vasarpota_at_my-deja.com wrote:
>
> Hi all,
>
> I have a problem. My SYSTEM Tablespace is fragmented because the
> default Temporary and User Tablespaces were not set properly by another
> DBA. How do I fix this problem?
>
> I have already gone through DBA_USERS and fixed the default tablespaces
> that created the problem but how do I unfragment the SYSTEM tablespace?
>
> What specific options of EXPORT, IMPORT should I use to make sure dont
> mess anything up?
>
> Thanks for your help,
>
> Vinnie
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================