MYDBA > create table test (a number);

Table created.

MYDBA > create index test_idx on test(a);

Index created.

MYDBA > create table test_new as select * from test;

Table created.

MYDBA > alter table test rename to test_old;

Table altered.

MYDBA > select table_name, index_name from user_indexes where table_name like 'TEST%';

TABLE_NAME                     INDEX_NAME
------------------------------ ------------------------------
TEST_OLD                       TEST_IDX

MYDBA >

scott@9i > create table mytbale (c1 number primary key, c2 blob);

Table created.

scott@9i > select table_name,index_name from user_indexes;

TABLE_NAME                     INDEX_NAME
------------------------------ ------------------------------
MYTBALE                        SYS_C001796
MYTBALE                        SYS_IL0000007570C00002$$