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

Because it isn't specifically mentioned in the Migration Guides (so far as I know) people tend leave the AUD$ table in the new tablespace and have found that, after migrating to a new version, they subsequently can't log in users until they disable auditing or stop auditing that event. Causes quite a little stir on a production database.

Not a problem if you remember to move it back to SYSTEM or disable auditing before migrating. Not recommended however.

td

Prem K Mehrotra wrote:
> 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 - 20:43:09 CDT