where I can find all icons in sql deveoper interface meaning? I found there are some different icons for table objects but don't know what's different.
I'm not aware of any documentation of the icons and their meaning.
I only have a couple of different 'table' icons: one solid one for traditional tables and one with a white gap in the middle for partitioned tables.
Object tables and IOTs seem to have the standard table icon.
If there are particular icons you have questions about post them and your full sql developer version and someone can help you identify them.
Thanks a lot! You described 2 icons for table but there are another one seems one-many specified, I don't know what's it mean.
Well no one can give a meaning when they can't see what you are looking at and you don't even describe it.
Click on the sql tab, look at the generated script and see what type of object is being created.
Index organised tables have a crow's foot attached to the table.
Temporary tables have what looks like a check box superimposed.
As somebody already said, there is no documentation of the various icons. Try looking at the ddl for tables with different icons and spotting the distinguishing feature.
But this table has different icon to traditional one.
The word 'different' doesn't mean anything. You have to describe the icon if you want someone to try to identify it for you. As Jim noted the words ORGANIZATION INDEX denoted the type of table so he was able to recognize it.
If you want help you have to provide the information needed to help you.
See the database concepts doc
An index-organized table has a storage organization that is a variant of a primary B-tree. Unlike an ordinary (heap-organized) table whose data is stored as an unordered collection (heap), data for an index-organized table is stored in a B-tree index structure in a primary key sorted manner. Besides storing the primary key column values of an index-organized table row, each index entry in the B-tree stores the nonkey column values as well.