dbTalk Databases Forums  

Can we do a alter sys index rebuild and alter sys table move?

comp.databases.oracle.marketplace comp.databases.oracle.marketplace


Discuss Can we do a alter sys index rebuild and alter sys table move? in the comp.databases.oracle.marketplace forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
charles
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.