Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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?
>
I've done ALTER TABLE MOVE to place AUD$ in another tablespace. IIRC, it is not officially supported, but it does work without any problems.
I'm not sure what document you were talking about, but it could have been written before the ALTER TABLE MOVE option was available. IIRC, the ability to to ALTER TABLE MOVE was first introduced in Oracle 8i.
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Fri Aug 04 2006 - 08:19:12 CDT