Can we do a alter sys index rebuild and alter sys table move? -
02-09-2011
, 06:38 PM
Deal group,
We are running Oracle 10.2.0.4 on linux.
Because an application problem, our aud$ table goes way too big, 20G.
That caused our system tablespace to 25G
So we moved aud$ out of system tablespace. But we cannot shrink the
system tablespace datafile becuase there are afew indexes belonging to
sys and one table at the high level of datafile.
I opened an TAR with Oracle, Oracle suggests me to do an export/
import, that is not possible
I am so attempted to do alter index sys.xx rebuild tablespace users;
shrink the datafile and rebuild it back. I tried to do it in a test
database, i did not seem to see any problem.
Did anybody do this before?
Thanks |