I need to rebuild the following object in an Oracle database...can somebody tell me how I would go about doing this?
Thanks in advance.
OBJECT ID = 576
OBJECT_NAME
OBJECT_TYPE
SMON_SCN_TIME_TIM_IDX INDEX
+1
A:
You need to connect as SYS (or equivalent privileges) and do this:
alter index smon_scn_time_tim_idx rebuild;
dpbradley
2010-08-24 16:18:28
Will this affect anything else?Thanks for your help...as a sys admin I'm not very well versed in a lot of the DBA sorta things.
2010-08-24 16:29:03
@user294746 - SMON is an Oracle background process (System MONitor)so anything do with it has the potential to impact everything else.
APC
2010-08-24 17:15:27
Rebuilding an index will not invalidate other objects. I should have asked - why are you rebuilding it - is it marked as INVALID?
dpbradley
2010-08-24 17:17:21
A:
What's your scope for downtime on the database ?
Playing with any SYSTEM / SYS object (especially on an unsupported database like XE) is dangerous.
Since XE is limited to 4GB in volume, I'd consider taking the DB offline / export / fresh install / import as a solution.
Gary
2010-08-24 23:27:49
I fixed the problem by dropping and recreating the indexes using the following:drop index smon_scn_time_scn_idx;drop index smon_scn_time_tim_idx;create unique index smon_scn_time_scn_idx on smon_scn_time(scn);create unique index smon_scn_time_tim_idx on smon_scn_time(time_mp);analyze table smon_scn_time validate structure cascade;
2010-08-25 16:33:44