Re: Unfragment SYSTEM Tablespace

In article <8ksv8g$93l$1_at_nnrp1.deja.com>,   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.
>

You cannot use export/import to defrag the system ts.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 17 2000 - 00:00:00 CDT