There are several occasions where Oracle implements new
features by creating extra segments behind the scenes.
In this particular case I think you have a LOB column at
column 7 of object 62950 - the index name you quote
is the LOBINDEX for that LOBSEGMENT. You can't
delete it, it is part of the implementation.
--
Jonathan Lewis
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html
For latest news of public appearances
See http://www.jlcomp.demon.co.uk
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
Jason Filby wrote in message <998915874.138857_at_proxy.storm.co.za>...
>Hey all
>
>I've created a table that is made up of custom object types. It seems that
>Oracle is creating temporary indexes with names like
>SYS_IL0000062950C0007$$. Does Oracle clean up these indexes? Is it the
>DBA's responsibility?
>
>Thanks
>- Jason
>
>
>Posted via www.orafocus.com - Focusing on the World of Oracle
>
Received on Mon Aug 27 2001 - 10:01:35 CDT
