Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Moving sys.aud$

Moving sys.aud$

From: Michael <melliott42_at_yahoo.com>
Date: 6 Jul 2004 18:27:48 -0700
Message-ID: <91721cf.0407061727.19c3a2b4@posting.google.com>


Hello,

I have inherited the maintenance of an Oracle 8.17 system with Auditing enabled. I have found that the sys.aud$ table is in the SYSTEM Tablespace and have been given a directive to move it out of SYSTEM. I am thinking that I should move the sys.aud$ table to a dedicated tablespace.

  1. How can I move this table to another Tablespace.
  2. Are there any special concerns in moving this table and\or auditing mechinisms?

Thanks for your advice,

Cal Received on Tue Jul 06 2004 - 20:27:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US