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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 26 Sep 2000 06:42:51 +0200
Message-ID: <969989168.9779.2.pluto.d4ee154e@news.demon.nl>

As sys is not exported -and you also *can't* export sys, the only way to defragment the system tablespace is to perform a *full* export and recreate the database (changing at the same time storage parameters in sql.bsq, without doing that you will get the same mess back).

Regards,

Sybrand Bakker, Oracle DBA

"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.
Received on Mon Sep 25 2000 - 23:42:51 CDT