On Mar 27, 12:52*pm, "jerni...@nospam.kochind.com"
<jerni...@kochind.com> wrote:
> Is it possible to export and then import specific sys objects without
> doing a full import?
>
> Basically my aud$ table got really large and made my system tablespace
> 6GB. * I moved the aud$ table. * I can't shrink it, because of some
> blocks in the idl_ub1$ table.
>
> I am running 10.2.0.3 on Solaris.

In addition to what David said, see metalink Note:166301.1. It
appears to be an old note, so I don't know how much really applies to
O10, but I'm thinking the bit about killing off auditable sessions may
be relevant, and maybe the shrinking part too.

Aren't you using sysaux? Won't moving it there help?

Apologies if anything I say doesn't make sense, I'm new to 10g, though
I've been watching the discussions about it for a long time. I just
got excited a few minutes ago about the segment advisor for one of my
issues.

jg
--
@home.com is bogus.
http://financial.washingtonpost.com/...=ORCL&nav= el