Oracle Database Discussions

Hi All ,

I was trying to re-build an index online .
It was taking lot of time and i was forced to kill the query .Please see the sqlplus screen output

SQL> create index rr_rtp_idx on router(marker) nologging parallel 8 online;

^C

*
ERROR at line 1:
ORA-01013: user requested cancel of current operation


Elapsed: 00:58:21.58


When i try to create index again in offline i got the following error

SQL> create index rr_rtp_idx on router(marker) nologging parallel 8
2 ;
create index rr_rtp_idx on router(marker) nologging parallel 8
*
ERROR at line 1:
ORA-00955: name is already used by an existing object

When i try to drop it i got following error

SQL> DROP INDEX SYS_C0016940;
DROP INDEX SYS_C0016940
***
ERROR at line 1:
ORA-08104: this index object 119463 is being online built or rebuilt


Elapsed: 00:00:00.02

But i am sure that no other queries are running to create this index online .

Can any one help me solve this issue.

Thanks