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

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

alter index smon_scn_time_tim_idx rebuild;