Re: import sys objects
Date: Thu, 27 Mar 2008 14:00:22 -0700 (PDT)
On Mar 27, 12:52 pm, "jerni..._at_nospam.kochind.com" <jerni..._at_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.
-- @home.com is bogus. http://financial.washingtonpost.com/custom/wpost/html-qcn.asp?dispnav=business&mwpage=qcn&symb=ORCL&nav=elReceived on Thu Mar 27 2008 - 16:00:22 CDT