Re: Question regarding moving sys.aud$ table
- From: Surachart Opun <surachart@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 1 Dec 2009 02:47:33 +0700
> "alter table sys.aud$ move tablespace xyz"
You can move it... But You have to noaudit your policy or stop audit...
before
Script on metalink...
create tablespace "AUDIT"
datafile '$HOME/data/aud01.dbf' size 500k
default storage (initial 100k next 100k pctincrease 0)
/
create table audx tablespace "AUDIT"
storage (initial 50k next 50k pctincrease 0)
as select * from aud$ where 1 = 2
/
rename AUD$ to AUD$$
/
rename audx to aud$
/
create index i_aud2
on aud$(sessionid, ses$tid)
tablespace "AUDIT" storage(initial 50k next 50k pctincrease 0)
/
*that doesn't need NOAUDIT on your Policy...*
>resize datafiles
- if tools tablespace be ASSM
You may shrink space tables + indexes on tools tablespace
- If tools tablespace be MSSM + ASSM
Check objects on tools tablespace and move them to new tablespace
And then "ALTER DATABASE DATAFILE '....' resize ...;"
Surachart Opun
http://surachartopun.com
On Tue, Dec 1, 2009 at 2:28 AM, hansie <hansrajsao@xxxxxxxxx> wrote:
> Hello All,
>
> sys.aud$ table is currently residing under tools tables space. which 80GB,
> but aud$ table is just 2GB. rest of space was used by perfstat which i have
> dropped. now there are 75GB space are free in tools tablespace. but i am not
> able to resize datafiles.
>
> I am thinking to move aud$ table to different tablespace and resize
> datafiles related to tools tablesspace.
>
> Quesiton: is it possible to move aud$ table suing "alter table sys.aud$
> move tablespace xyz"
> and resize datafiles then move back aud$ to tools tablespace.
> reason for asking this question is, in metalink note it say need to create
> different aud$_1 table then insert record from original aud$ table then drop
> aud$ and rename aud$_1 to aud$.
>
> my datababe version is 10.2.0.2.
>
>
> --
> Thanks,
> Hansraj
>
>
Other related posts:
