[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


System Index rebuild in Oracle 9i

Posted on 2009-12-22
Medium Priority
Last Modified: 2013-12-19
Hi All,

I am planning to rebuild SYS_C002518 index. i think it is system index.

Reson for rebuild:
one of my dbf file is corrupted and in log file it was showing 'UAI_USER_ACC_INFO' table. so using below query i find the index name:

select index_name from all_indexes
where table_name = 'UAI_USER_ACC_INFO';


My question is, i am planning to rebuild this index using below script.
alter index SYS_C002518 rebuild;

rebuilding this index is there any issues/problems?
Question by:srinivas_ganamur

Expert Comment

ID: 26104602
select tablespace_name from dba_indexes where index_name='SYS_C002518';

it`s hardly seems to be a system index, it was implicitly named by system.

Accepted Solution

fluglash earned 1500 total points
ID: 26104624
also check the owner of the table index built on:

select table_owner from dba_indexes where index_name='SYS_C002518';
LVL 15

Expert Comment

by:Devinder Singh Virdi
ID: 26108308
>>rebuilding this index is there any issues/problems?
There is no issue in doing that. Did you analyze the table 'UAI_USER_ACC_INFO'

Expert Comment

ID: 26111145
It does't seem to be system table so this index is not a system index.
Any way there is no issue to rebuild the index whether it is system or user defined.

Author Closing Comment

ID: 31668899
no proper solution

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question