• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 767
  • Last Modified:

System Index rebuild in Oracle 9i

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

Output:
SYS_C002518

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?
0
srinivas_ganamur
Asked:
srinivas_ganamur
1 Solution
 
fluglashCommented:
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.
0
 
fluglashCommented:
also check the owner of the table index built on:

select table_owner from dba_indexes where index_name='SYS_C002518';
0
 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
>>rebuilding this index is there any issues/problems?
There is no issue in doing that. Did you analyze the table 'UAI_USER_ACC_INFO'
0
 
ravibhardwajCommented:
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.
0
 
srinivas_ganamurAuthor Commented:
no proper solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now