System Index rebuild in Oracle 9i

Posted on 2009-12-22
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
    LVL 7

    Expert Comment

    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.
    LVL 7

    Accepted Solution

    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
    >>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

    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

    no proper solution

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Salary Amount Format 13 51
    CREATE TABLE syntax 4 33
    Oracle SQL Select Statement 19 45
    Need help with Oracle syntax 4 32
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now