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

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!
========================================