开发者

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

开发者 https://www.devze.com 2023-01-13 11:21 出处:网络
I need to rebuild the following ob开发者_StackOverflow中文版ject in an Oracle database...can somebody tell me how I would go about doing this?

I need to rebuild the following ob开发者_StackOverflow中文版ject 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


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

alter index smon_scn_time_tim_idx rebuild;


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消