Re: exp owner=sys, system compress=y?

I may be wrong but I think if you set the pctincrease on the system tablespace to zero, you will shortly have objects which have thrown an awful lot of extents. Oracle's default when it creates a system tablespace is to set pctincrease to 50%.

Van

"Brian Peasland" <peasland_at_edcmail.cr.usgs.gov> wrote in message news:39D0A034.A206CC51_at_edcmail.cr.usgs.gov...
> The only way to remove fragmentation is to export the data, delete the
> database, recreate the database with a modified sql.bsq file so as to
> reduce fragmentation, and then import the data. You can not export just
> the SYS tables.
>
> But the bigger question is why are you worried about this? Are you sure
> that fragmentation is slowing your database performance? Fragmented
> tables are not the death knell for high performing databases. Many
> databases run just fine with fragmentation, especially OLTP systems.
>
> HTH,
> Brian
>
>
> NetComrade wrote:
> >
> > Hi,
> >
> > My system tablespace is getting fairly fragmented.
> > I was wondering if anybody has been able to successfully rebuild it
> > w/o any probs via imp/exp.
> >
> > Thanx.
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Tue Sep 26 2000 - 17:52:17 CDT