Question regarding moving sys.aud$ table
Date: Mon, 30 Nov 2009 14:28:05 -0500
Message-ID: <16c554d50911301128g2e148878kc9227f7eab208845_at_mail.gmail.com>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 30 2009 - 13:28:05 CST