Re: Move table sys.aud$ to another tablespace

sybrandb wrote:
> emdproduction_at_hotmail.com wrote:
> > In metalink, there is an article talking about moving sys.aud$ to
> > another tablespace.
> >
> > 1)create tablespace "AUDIT" datafile '$HOME/data/aud01.dbf' size 500k
> > default storage (initial 100k next 100k pctincrease 0)
> >
> > 2)create table audx tablespace "AUDIT" storage (initial 50k next 50k
> > pctincrease 0) as select * from aud$ where 1 = 2
> >
> > 3) rename AUD$ to AUD$$
> >
> > 4)rename audx to aud$
> >
> > 5)create index i_aud2
> > on aud$(sessionid, ses$tid)
> > tablespace "AUDIT" storage(initial 50k next 50k pctincrease 0)
> >
> > Can't we just do "alter table AUD$ move tablespace"???
> >
> > Anything wrong with doing alter table stetement on sys.AUD$ table?
>
> Hopefully you did read the article carefully. Oracle doesn't support
> moving sys.AUD$.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

I could very well be wrong (often am) but I think this is kind of like altering sessions to get a 10046 trace ... officially unsupported (outside the direct supervision of Oracle support) but well documented, well known, and widely used. It's my understanding that it is desirerable to get a volatile table like AUD$ out of the system tablespace. Received on Fri Aug 04 2006 - 10:03:21 CDT