Re: RE-Orging strategies

Hi:
In fact objects in sys schema should never be exported or imported. Even you exp/imp full database, sys's objects are not included. There is no different use sys or system to exp/imp other schema's objects, but never exp/imp sys's objects.

Michael Zhang.

Doug Cowles <dcowles_at_bigfoot.com> wrote in message news:377FADEA.21421B2F_at_bigfoot.com...
> A DBA at my account generally likes to re-create databases from scratch
> to do a re-org, and can afford to do so because the databases are a
> couple of Gigs
> at best. I'm wondering though about doing full imports as sys or
> system.
> All of my exports are done with compress=Y, and when I drop users
> cascade,
> I've had no problem re-importing a full export file to do the job. What
> I'm wondering
> though is, what's the diff between doing it as sys or system. I could
> sware that even
> if I do things as sys, I get messages to effect of " Not doing this,
> object already exists",
> meaning that stuff from running catproc, etc., a long time ago is still
> there, so it's not
> going to pop stuff on top of it. So if importing as either sys or
> system does not engage
> in a full replacement of the database (is that right?), then what's the
> advantage of using
> one or the other. I suspect sys will import sys's objects, and system
> will not, but
> neither option engages in a full replacement, does it?
>
> - Dc.
>
Received on Sun Jul 04 1999 - 18:32:37 CDT