Re: Question regarding moving sys.aud$ table
- From: Michael Fontana <michael.fontana@xxxxxxxxxxx>
- To: hansrajsao@xxxxxxxxx
- Date: Mon, 30 Nov 2009 13:48:36 -0600 (CST)
I would first try to get my database upgraded to 10.2.0.4 with the highest
available patchset. There are some patches and fixes concerning movement of
the aud$ object, including a package to make the job easier (per Metalink note:
72460.1). Anothing to consider - if you have this much data in this table,
perhaps a pruning effort should be considered?
----- Original Message -----
From: "hansie" <hansrajsao@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Monday, November 30, 2009 1:28:05 PM GMT -06:00 US/Canada Central
Subject: Question regarding moving sys.aud$ table
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
--
Michael Fontana
Sr. Technical Consultant
Enkitec M: 214.912.3709
enkitec
oracle_certified_partner
--
//www.freelists.org/webpage/oracle-l
Other related posts:
