Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    70

    Thumbs up Unanswered: table definition missing

    Hi All,
    I am able to view a particular table information in DBA_OBJECTS & USER_OBJECTS, whereas the same table information is missing in DBA_SEGMENTS, USER_SEGMENTS & DBA_EXTENTS.

    Can anyone tell me why?


    Thanks in advance
    qA

  2. #2
    Join Date
    Sep 2003
    Location
    Milan, Italy
    Posts
    130

    gtt, iot ...

    [pre]
    SQL> create GLOBAL TEMPORARY table gtt (x int);

    Table created.

    SQL> create table iot (x int primary key) organization index;

    Table created.

    SQL> create table normal (x int);

    Table created.

    SQL> select table_name from user_tables where table_name in ('GTT','IOT','NORMAL');

    TABLE_NAME
    --------------------------------------------------------------------------------
    GTT
    IOT
    NORMAL

    SQL> select segment_name from user_segments where segment_name in ('GTT','IOT','NORMAL');

    SEGMENT_NAME
    --------------------------------------------------------------------------------
    NORMAL

    SQL> select index_name from user_indexes where table_name='IOT';

    INDEX_NAME
    --------------------------------------------------------------------------------
    SYS_IOT_TOP_30629

    SQL> select segment_name from user_segments where segment_name = 'SYS_IOT_TOP_30629';

    SEGMENT_NAME
    --------------------------------------------------------------------------------
    SYS_IOT_TOP_30629

    [/pre]

    The global temporary table has no permanent segment; a TEMPORARY segment is dynamically allocated (in the temporary tablespace) as soon as any user references it (one segment for each user).

    The Index Organized Table is a "tableless index" - hence the name of the segment is that of the index, not that of the table.

    bye
    al

  3. #3
    Join Date
    Jul 2003
    Posts
    70

    Thumbs up

    Hi
    Thanks for the reply. It was really informative. I think my table is IOT,
    BTW can you tell me how would I know whether my table is really IOT or not?

    Thank in advance
    qA

  4. #4
    Join Date
    Sep 2003
    Location
    Milan, Italy
    Posts
    130
    dba_tables.IOT_TYPE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •