Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Unanswered: Converting indexed Oracle table to MySQL

    Hi there,

    This is my first posting so if I miss any relevant info please just ask for more detail.

    I am converting an Oracle 8i db to MySQL. The problem I am having is that the oracle db used indexed tables e.g.

    create table genre (
    id numeric primary key,
    name varchar(32)
    organization index;

    From what I have read of Oracle this is an Index Organized Table, which I have never heard of before. I read a little on the Oracle web site but not being a db admin there was much I didn't understand.

    I want to transpose this to a MySQL db but am unsure how to index the tables in the way specified in the Oracle db table.



  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >Index Organized Table
    AFAIK, MySQL does not have any similar construct as Oracle IOT.
    An IOT is an object where the "table" and the "index" are the same single object.
    Another way of viewing an IOT is where all the columns in the table comprise the index. Now since nothing is gained by having the table, the IOT is just the index with no underlying table.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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