This discussion is archived
11 Replies Latest reply: Sep 11, 2012 8:06 PM by rp0428 RSS

sql developer icon's mean

liwen zhang Newbie
Currently Being Moderated
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.
Thanks a lot!
  • 1. Re: sql developer icon's mean
    rp0428 Guru
    Currently Being Moderated
    >
    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.
  • 2. Re: sql developer icon's mean
    liwen zhang Newbie
    Currently Being Moderated
    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.
  • 3. Re: sql developer icon's mean
    rp0428 Guru
    Currently Being Moderated
    >
    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.
  • 4. Re: sql developer icon's mean
    liwen zhang Newbie
    Currently Being Moderated
    for example:
    CREATE
    TABLE "SH"."DR$SUP_TEXT_IDX$K"
    (
    "DOCID" NUMBER(38,0),
    "TEXTKEY" ROWID,
    PRIMARY KEY ("TEXTKEY") ENABLE
    )
    ORGANIZATION INDEX NOCOMPRESS PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
    STORAGE
    (
    INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0
    FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT
    CELL_FLASH_CACHE DEFAULT
    )
    TABLESPACE "EXAMPLE" PCTTHRESHOLD 50;

    But this table has different icon to traditional one.
  • 5. Re: sql developer icon's mean
    Jim Smith Expert
    Currently Being Moderated
    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.
  • 6. Re: sql developer icon's mean
    rp0428 Guru
    Currently Being Moderated
    >
    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.
  • 7. Re: sql developer icon's mean
    liwen zhang Newbie
    Currently Being Moderated
    Thanks all of you!

    I guess that the table is crow's foot attached to the table icon.

    I need to understand what's organized index.
  • 8. Re: sql developer icon's mean
    liwen zhang Newbie
    Currently Being Moderated
    I hope I can describe clearly with a picture but no that function here.
  • 9. Re: sql developer icon's mean
    rp0428 Guru
    Currently Being Moderated
    >
    ORGANIZATION INDEX
    >
    That in your DDL indicates an IOT
  • 10. Re: sql developer icon's mean
    liwen zhang Newbie
    Currently Being Moderated
    Yes, I noticed. Thank you very much!

    Edited by: user12063985 on 2012-9-11 下午8:00
  • 11. Re: sql developer icon's mean
    rp0428 Guru
    Currently Being Moderated
    See the database concepts doc
    http://docs.oracle.com/cd/B28359_01/server.111/b28318/schema.htm#CNCPT911
    >
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points