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

    Unanswered: Converting indexed Oracle db 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
    Jul 2004
    Dundee, Scotland
    just export the table data (id and name fields) from Oracle, create the table in MySQL with a primary key, then import the data.

    depending on the use of the table you might want to enable auto_increment for the id field.

Posting Permissions

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