Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Move table sys.aud$ to another tablespace

Move table sys.aud$ to another tablespace

From: <emdproduction_at_hotmail.com>
Date: 4 Aug 2006 05:53:33 -0700
Message-ID: <1154696013.254912.285490@p79g2000cwp.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US