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

Hi,

There are two Oracle notes on metalink that describe moving SYS.AUD$, they are Note 72460.1 and Note 1019377.6 - both describe the process, although slightly differently. If you move SYS.AUD$ then the upgrade process can fail and possibly a patching as well (depending on what is patched). Oracle don't officially support miving SYS.AUD$ but you can do it. One of the notes describes adding a trigger on the moved table. If you disable audit or move aud$ back for an upgrade then there shouldnt be a problem. If you move AUD$ to a new user then you should be able to range partition it.

The reason Oracle gives for not supporting moving AUD$ is that the internal code makes assumptions about data dictionary tables such as AUD$ which could cause issues with upgrade and recovery.

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.