ROW_NO is not a reserved term in Oracle.

That is interesting, could you do the following for me in the 9i and 11g databases:

select * from dba_indexes where table_name = 'YOUR_TABLE';
select * from dba_constraints where table_name = 'YOUR_TABLE';

Also of interest would be to do:

imp indexfile=idx.sql

and have a peruse through idx.sql to see what objects were in the dmp file.

If you want to email any of this to me, send it to: asktom_us@oracle.com

Addenda:

Ah, now you have provided the name of the object, it becomes clear. The table is not an object *you* created, it is an object that *we* created (to support an Oracle Text index). The *structure* of the objects we create can change between versions.

For example, in (say) version 7, an Oracle Text index might create 3 tables to support the index. In 12c, it might create 6 tables.

In *both* cases, the import would have seen:

create index BLAH on MYTABLE ( ) indextype is ctx_syx.something

Hope this helps.