From oracle-l-bounce@freelists.org Fri Nov 19 02:03:46 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iAJ83kb01575 for ; Fri, 19 Nov 2004 02:03:46 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iAJ83ki01570 for ; Fri, 19 Nov 2004 02:03:46 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BB69D72DDD3; Fri, 19 Nov 2004 03:10:04 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32389-40; Fri, 19 Nov 2004 03:10:04 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 43F5A72DBA6; Fri, 19 Nov 2004 03:09:46 -0500 (EST) Message-ID: <20041119080735.48167.qmail@web86909.mail.ukl.yahoo.com> Date: Fri, 19 Nov 2004 08:07:35 +0000 (GMT) From: Connor McDonald Subject: Re: sys.aud$ not in sysaux tablespace by default - what gives? To: Oracle-L-freelists In-Reply-To: <910046b404111814282aef9e5d@mail.gmail.com> MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 12424 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: hamcdc@yahoo.co.uk Precedence: normal Reply-To: hamcdc@yahoo.co.uk X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Most Oracle upgrades are mandated by conditions of "fixed time to upgrade independent of database size". Oracle doesn't know if you've got 100's of gig's of audit data so it would not be prudent to move it as part of the upgrade process, so it has to stay where it is (wherever that may be). However, I agree that it should be supported to relocate to SYSAUX once a db is installed. Interestingly, one of the Metalink notes about pre-reqs for upgrade to 10 is to ensure AUD$ is in SYSTEM if auditing is enabled during the process. hth connor --- Paul Drake wrote: > It was my understanding that the segment sys.aud$ would be created in > the sysaux tablespace in 10g. > I guess I assumed too much. > > 10.1.0.3 Std Ed lin32 > RHEL 3.0 ES Update 2 (current) > > sys.aud$ is still in the system tablespace, not in sysaux. > checked metalink. > used a search engine. > found no docs covering the SUPPORTED altering of this. > > Does anyone know if it is supported by Oracle to move this table from > the System tablespace into the sysaux tablespace? > > Paul > -- > http://www.freelists.org/webpage/oracle-l > ===== Connor McDonald Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk web: http://www.oaktable.net email: connor_mcdonald@yahoo.com Coming Soon! "Oracle Insight - Tales of the OakTable" "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" ------------------------------------------------------------ ___________________________________________________________ Moving house? Beach bar in Thailand? New Wardrobe? Win £10k with Yahoo! Mail to make your dream a reality. Get Yahoo! Mail www.yahoo.co.uk/10k -- http://www.freelists.org/webpage/oracle-l