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

You can't export objects owned by SYS -which means the data dictionary tables are all un-exportable. And given that they should be the only things in the system tablespace, an export and an import aren't exactly going to do an awful lot for you.

Have you tried an 'alter tablespace system coalesce'?

I'd also contemplate alter tablespace system default storage (pctincrease 0).

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



"NetComrade " <andreyNSPAM_at_bookexchange.net> wrote in message
news:37ed634d.26629911_at_news.earthlink.net...


> 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.