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 -> Is is possible to range partition sys.aud$ table ...

Is is possible to range partition sys.aud$ table ...

From: Prem K Mehrotra <premmehrotra_at_hotmail.com>
Date: 7 Jul 2004 05:24:37 -0700
Message-ID: <43441e77.0407070424.396afe1b@posting.google.com>


Even though not supported by Oracle, people move sys.aud$ table to a different tablespace (as dicussed in this news group as well as in some books). My
question is, is it also possible to partition (range) this table based on timestamp or so. I have to keep seven years worth of audit data and I wanted
to keep each quarter's audit data in a separate partition. I will think it is
risky to partition the aud$ table because aud$ table is created by Oracle but just
wanted to get other's opinions If I cannot partition the aud$ table, I was thinking of creating my own table and then have a job to periodically l move data from aud$ to my table.

Thanks,

Prem Received on Wed Jul 07 2004 - 07:24:37 CDT

Original text of this message

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