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.

MARK

CIAO

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.