How would I go about rebuilding an object in an Oracle XE database?

Question

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

Answer 1

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.

Answer 2

You need to connect as SYS (or equivalent privileges) and do this:

alter index smon_scn_time_tim_idx rebuild;