Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is is possible to range partition sys.aud$ table ...
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