Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Move table sys.aud$ to another tablespace
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? Received on Fri Aug 04 2006 - 07:53:33 CDT
![]() |
![]() |