Re: Move table sys.aud$ to another tablespace

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